Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

A)SELECT AVG (Balance) FROM CUSTOMER WHERE SalesRepNo;
B)SELECT AVG (Balance) FROM CUSTOMER GROUP BY SalesRepNo;
C)SELECT AVG (Balance) FROM CUSTOMER,SALESREP WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;
D)SELECT AVG (Balance) FROM CUSTOMER ORDER BY SalesRepNo;
E)SELECT AVG (Balanc
E) FROM CUSTOMER,SALESREP WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo HAVING SalesRepNo;

Question

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

A)SELECT AVG (Balance) FROM CUSTOMER WHERE SalesRepNo; 
B)SELECT AVG (Balance) FROM CUSTOMER GROUP BY SalesRepNo; 
C)SELECT AVG (Balance) FROM CUSTOMER,SALESREP WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo; 
D)SELECT AVG (Balance) FROM CUSTOMER ORDER BY SalesRepNo; 
E)SELECT AVG (Balanc
E) FROM CUSTOMER,SALESREP WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo HAVING SalesRepNo;

Quizplus · Accepted Answer

To group the average customer balance by SalesRepNo, we need to use the GROUP BY clause with the SalesRepNo column from the Customer table. Therefore, option B is the correct choice. Option A only calculates the average balance without grouping by SalesRepNo. Option C uses a join between the Customer and SalesRep tables but doesn't include a GROUP BY clause. Option D only orders the results by SalesRepNo but doesn't calculate the average. Option E has a mistake in the WHERE clause and also doesn't include a GROUP BY clause.

Based on the Tables Below,which of the Following ANSI SQL