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