Skip to content
RED SAGSkills
medium10 pts · first answer countssqljoins

WHERE filter after a LEFT JOIN

customers A, B, C. orders: A has amounts 50 and 70, B has 30, C has none. How many rows does this query return?

SELECT c.name, o.amount
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
WHERE o.amount > 40;
Choose one answer