SQL practice › Joins & grouping
Best-Selling Product
Medium · Joins & grouping
Return the name of the product with the highest total quantity sold across all orders that were not cancelled, and that quantity.
Hint
Group by product, order by the total, take the first row.
Write your query on this page — it runs against the sample company database in your browser and is checked instantly.
Next problem: Salary Rank in Department