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