04 Calculate

-- 04_calculate: Compute line sales and label a discount
-- Read-only reference query. Setup must be loaded first.
SELECT order_id, line_no,
 quantity * unit_price - line_discount AS line_sales,
 CASE WHEN line_discount > 0 THEN 'discounted' ELSE 'full_price' END AS price_type
FROM aabha_sql.order_items WHERE order_id IN (1004,1006)
ORDER BY order_id,line_no;