04A
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
-- 04a: Compute discounted lines for order 1005
SELECT quantity*unit_price AS before_discount,line_discount,
quantity*unit_price-line_discount AS line_sales FROM aabha_sql.order_items WHERE order_id=1005;