Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
helpmepls helpmepls
wrote...
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 58 times
2 Replies
Replies
Answer verified by a subject expert
chenandrew1219chenandrew1219
wrote...
Posts: 211
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...
5 years ago
Thanks
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1099 People Browsing
Related Images
  
 337
  
 284
  
 278