Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
helpmepls helpmepls
wrote...
Go to Answer
Posts: 318
Rep: 0 0
5 years 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

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 66 times
2 Replies
Replies
Answer verified by a subject expert
chenandrew1219chenandrew1219
wrote...
#1
Posts: 211
Rep: 182 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

helpmepls Author
wrote...
#2
5 years ago
Thanks
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1164 People Browsing
 154 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 10251
  
 815
  
 712
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 741
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?