Debug: Duplicate Rows After Join

Interviewer prompt: Revenue report doubled values after joining order_items and promotions. SELECT o.order_id, SUM(oi.amount) AS revenue FROM orders o JOIN order_items oi ON o.order_id = oi.order_id JOIN promotions p ON o.order_id = p.order_id GROUP BY o.order_id; Fix query shape.