Skip to main content
All Problems
medium0% acceptance

Order Line Items with Product Details

Build a detailed invoice view. For each order_item, show the order_id, product name, quantity, unit_price, discount, and the line total (quantity * unit_price - discount). Sort by order_id then product name.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute