07 Fanout

-- 07_fanout: Diagnose the deliberately wrong total
-- Read-only reference query. Setup must be loaded first.
-- Deliberately incorrect sales metric: two independent child tables multiply rows.
SELECT i.order_id,COUNT(*) AS joined_rows,
 SUM(i.quantity*i.unit_price-i.line_discount) AS inflated_sales
FROM aabha_sql.order_items AS i JOIN aabha_sql.payments AS p ON p.order_id=i.order_id
WHERE i.order_id=1001 AND p.status='succeeded'
GROUP BY i.order_id;