medium10 pts · first answer countssqljoinsdata-modeling
Revenue doubled after a join
orders: order 1 = 100, order 2 = 50. order_items: order 1 has 3 items, order 2 has 1 item. What does this query return?
SELECT SUM(o.amount) FROM orders o JOIN order_items i ON i.order_id = o.order_id;