medium10 pts · first answer countssqljoins
Customers who never ordered
Customers are Asha (1), Bilal (2), Chen (3), Dina (4) and Eli (5). Only customers 1, 2 and 3 have orders. What does this query return?
SELECT c.name FROM customers c LEFT JOIN orders o ON o.customer_id = c.id WHERE o.id IS NULL;