order_items links orders to products: each row is one product in one order. For every
line of order 1, show product_id, quantity, unit_price and line_total: the quantity times
the unit price, less discount_pct percent, rounded to 2 decimal places.
End your query with ORDER BY product_id.
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| quantity |
| unit_price |
| discount_pct |
order_items links orders to products: each row is one product in one order. For every
line of order 1, show product_id, quantity, unit_price and line_total: the quantity times
the unit price, less discount_pct percent, rounded to 2 decimal places.
End your query with ORDER BY product_id.
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| quantity |
| unit_price |
| discount_pct |
| product_id | quantity | unit_price | line_total |
|---|---|---|---|
| 1 | 1 | 24999.00 | 24999.00 |
| 19 | 1 | 499.00 | 449.10 |
Run query to see output