Link Search Menu Expand Document

183. Customers Who Never Order

Solution Code

MySQL

SELECT Customers.Name AS Customers
FROM Customers
LEFT JOIN Orders ON Customers.Id = Orders.CustomerId
WHERE Orders.CustomerId IS NULL;

© 2023. All rights reserved.