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
Apr 06, 2014 at 03:48 AM
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.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Apr 06, 2014 at 03:48 AM
Seen: 673 times
Last Updated: Apr 06, 2014 at 09:29 AM
get column name and view it using php
Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names
Ordering Data in Specific manner
Select DISTINCT from one column but ORDER BY another
Current total per year
Can anyone tell me why this query takes 8 seconds to load?
How can I order this?
Reporting Database recommendation
SQL 2008 - Suspended - ASYNC_NETWORK_IO
full text search has changed in sql server 2008