x

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

more ▼

asked Apr 06, 2014 at 03:48 AM in Default

avatar image

rnofx5
1 2 2 3

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.

Apr 06, 2014 at 09:29 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1127
x28
x9
x5
x3

asked: Apr 06, 2014 at 03:48 AM

Seen: 674 times

Last Updated: Apr 06, 2014 at 09:29 AM

Copyright 2017 Redgate Software. Privacy Policy