Based on the SQL Shown, for Each Sales Rep, Which

question 47

Multiple Choice

Based on the SQL shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? Group and order the records by rep number. Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A)SELECT RepNum, AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• B)SELECT RepNum, COUNT(RepNum), AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• C)SELECT RepNum, COUNT(*), AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• D)SELECT RepNum, COUNT(*) FROM Customers GROUP BY RepNum ORDER BY RepNum;

---

Definitions:

Depressed

A state of low mood and aversion to activity, affecting a person's thoughts, behavior, feelings, and sense of well-being.

Relational De-Escalation

The process of reducing the intensity or seriousness of a relationship.

Standard Reply

A routine or expected response to a common question or situation.

Post-Separation

The period or condition following the end of a relationship or partnership.