Top Posters
Since Sunday
27
26
25
22
21
21
21
20
20
20
19
19
New Topic  
wrote...
Posts: 289
Rep: 0 0
2 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;
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 12 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 207
2 months ago
Sign in or Sign up in seconds to unlock everything.
SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;
1
Related Topics
wrote...
2 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
  345 People Browsing
 140 Signed Up Today
Related Images
 911
 147
 130