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

Based on the tables below, which of the following SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE: SALESREP CUSTOMER SELECT AVG (Balance) FROM CUSTOMER GROUP BY SalesRepNo; SELECT AVG (Balance) FROM CUSTOMER, SALESREP WHERE SALESREP.SalesRepNo - CUSTOMER.SalesRepNo; SELECT AVG (Balance) FROM CUSTOMER WHERE SalesRepNo; SELECT Balance FROM CUSTOMERAS C ORDER BY C.SalesRepNo
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
