Skip to main content
All Problems
medium0% acceptance

Total Revenue per Product Category

The finance team wants total revenue broken down by product category. Calculate the sum of (quantity * unit_price) from order_items, grouped by category name. Only include orders with status 'delivered'. Sort by total revenue descending.

Schema

🔑idINT
nameTEXT
descriptionTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute