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