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

Multiple Choice

Based on the code 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? The records are grouped by rep number and ordered by rep number.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

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