Skip to content
RED SAGSkills
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;
Choose one answer