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: 677 times
Last Updated: Apr 06, 2014 at 09:29 AM
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
get column name and view it using php
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?
How should I make my application ANSI compliant
Netapp filer was going to be replaced in clustering environment
connect to sql “server group” with php to run query over mutiple databases