Skip to main content
All Problems
medium0% acceptance

Order Items with Full Details

Build a detailed line-item report. For each order item, show the order id, product name, category name, quantity, unit_price, and line total (quantity * unit_price). Sort by order id, then product name.

Schema

🔑idINT
nameTEXT
descriptionTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute