Top Posters
Since Sunday
79
20
16
15
12
10
10
9
9
8
8
8
New Topic  
wrote...
Posts: 288
Rep: 0 0
5 months ago
Based on the tables below, which of the following SQL commands would return the average customer balance grouped by SalesRepNo?

GENERAL SALES DATABASE:

SALESREP
SalesRepNoRepNameHireDate
654Jones01/02/2005
734Smith02/03/2007
345Chen01/25/2018
434Johnson11/23/2004

CUSTOMER
CustNoCustNameBalanceSalesRepNo
9870Winston500345
8590Gonzales350434
7840Harris800654
4870Miles100345


• 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;
Textbook 
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 30 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 207
5 months ago
Sign in or Sign up in seconds to unlock everything.
SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;
1
Related Topics
wrote...
5 months ago
Thanks
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  78 People Browsing
Your Opinion
Related Images
 472
 1220
 172