Based on the Code Above,for Each Sales Rep,list the Rep

Multiple Choice

Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.​

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 ;