BiruLyu
6/1/2017 - 4:50 PM

183. Customers Who Never Order(1st).sql

# Write your MySQL query statement below
SELECT Name AS Customers
FROM Customers
WHERE Id NOT IN (SELECT CustomerId FROM Orders);
# Write your MySQL query statement below
SELECT C.Name AS Customers
FROM Customers C
LEFT JOIN (SELECT DISTINCT CustomerId FROM Orders) O
ON C.Id = O.CustomerId
WHERE O.CustomerId IS NULL;