question

rnofx5 avatar image
rnofx5 asked

Write a sub-query that returns the total number of orders placed by the customer with the highest number of orders. Include the customerid and the number of orders placed

Write a sub-query that returns the total number of orders placed by the customer with the highest number of orders. Include the customerid and the number of orders placed
sqlorder-byorderingtotalsub-total
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Even if people are inclined to do your homework for you, without the data model, it's going to be pretty hard to come up with a correct answer. Could you possibly show what you've tried that hasn't worked and then maybe someone could make some suggestions.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.