Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ProductName, Count(OrderDetails.OrderID) as Quantity
- FROM Products
- JOIN OrderDetails
- USING (ProductID)
- Group by ProductName
- Order by count(OrderDetails.OrderID) desc limit 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement