LeetCode[MySQL] : Customers Who Never Order

Customers Who Never Order

Q

SELECT name AS 'Customers'
FROM Customers 
WHERE id NOT IN (SELECT C.id FROM Customers C INNER JOIN Orders O ON O.customerId = C.id)