Skip to main content
All Problems
medium0% acceptance

Top-Selling Category by Quantity

Find the product category with the highest total quantity sold. Use a subquery in the FROM clause to first calculate total quantity per category, then select the top one. Return category name and total_quantity.

Schema

🔑idINT
nameTEXT
descriptionTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute