Advertisement
yatahaze

PavloSheichenko

Feb 20th, 2023
546
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.18 KB | None | 0 0
  1. SELECT ProductName, Count(OrderDetails.OrderID) as Quantity
  2. FROM Products
  3. JOIN OrderDetails
  4. USING (ProductID)
  5. Group by ProductName
  6. Order by count(OrderDetails.OrderID) desc limit 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement