Biology Forums - Study Force

Based on the tables below, which of the following SQL commands would return the average customer balance grouped by SalesRepNo?

GENERAL SALES DATABASE:

SALESREP

SalesRepNo	RepName	HireDate
654	Jones	01/02/2005
734	Smith	02/03/2007
345	Chen	01/25/2018
434	Johnson	11/23/2004

CUSTOMER

CustNo	CustName	Balance	SalesRepNo
9870	Winston	500	345
8590	Gonzales	350	434
7840	Harris	800	654
4870	Miles	100	345

• SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo;

• SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;

• SELECT AVG (Balance)
FROM CUSTOMER, SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;

• SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo;

Content hidden