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

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;