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;
Correct Answer:
Verified
Q29: Based on the SQL shown, which query
Q30: Based on the SQL shown, which query
Q31: When you place one query inside another,
Q32: Which of the following SQL commands sorts
Q33: The Clients table contains 12 records with
Q35: Based on the SQL shown, which query
Q36: What SQL keyword do you use in
Q37: Which statement creates a table named PostalCodes
Q38: Based on the table description and SQL
Q39: What SQL command do you use to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents