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;