Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

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