183. Customers Who Never Order

[QuXiangjie]

Question

SELECT c1.name as Customers
FROM Customers c1
LEFT JOIN Orders o ON c1.id = o.customerId
WHERE o.customerId IS NULL;

IS NULL can be used for NULL value