Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.12 KB | None | 0 0
  1. SELECT OrderID, COUNT(ProductID) AS '# of Items' FROM orderdetails
  2. GROUP BY OrderID
  3. ORDER BY COUNT(ProductID) DESC
  4. LIMIT 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement