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 ;

Question

Quizplus · Accepted Answer

This query selects the necessary columns (RepNum, COUNT(*), AVG(Balance)) and groups them by RepNum, allowing for the number of customers and average balance for each rep to be calculated. The records are then ordered by rep number. Option A only selects the RepNum and average balance, omitting the customer count. Option B selects the incorrect table name (Part instead of Customer). Option D only selects the RepNum and customer count, omitting the average balance.

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