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