× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
thegingercoffee thegingercoffee
wrote...
Go to Answer
Posts: 660
Rep: 0 0
6 years ago
Based on the code above, for each sales rep, list the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers. Group the records by rep number and order the records by rep number.
 a. SELECT RepNum, AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
 b. SELECT RepNum, COUNT(), AVG(Balance) FROM Part GROUP BY RepNum ORDER BY RepNum ;
  c. SELECT RepNum, COUNT(), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
  d. SELECT RepNum, COUNT() FROM Customer GROUP BY RepNum ORDER BY RepNum ;
Read 39 times
2 Replies
Replies
Answer verified by a subject expert
jgfndjgfnd
wrote...
#1
Top Poster
Posts: 871
Rep: 1 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

wrote...
#2
6 years ago
I can't even begin to explain how much your help meant to me.
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1270 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 1255
  
 255
  
 1325
Your Opinion
Where do you get your textbooks?
Votes: 372
Previous poll results: Which country would you like to visit for its food?