Skip to content

183. Customers Who Never Order 👍

1
2
3
4
5
SELECT Customers.name AS Customers
FROM Customers
LEFT JOIN Orders
  ON (Customers.id = Orders.customerId)
WHERE Orders.id IS NULL;