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;

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;

Quizplus · Accepted Answer

To group the average customer balance by SalesRepNo, we need to use the GROUP BY clause. This option is only present in choice B, which is the correct answer. Choice A is incorrect because it does not include the SalesRepNo in the query. Choice C is incorrect because it includes the SalesRep table, but it does not group the results by SalesRepNo, and it would result in showing the same data repeatedly, since there could be many customer records to a sales representative. Choice D is incorrect because it orders the results by SalesRepNo, but does not group them.

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