[MySQL실습] 183. Customers Who Never Order

정답

SELECT Customers.name AS Customers
FROM Customers
    LEFT JOIN Orders On Customers.id = Orders.customerId
WHERE Orders.id is NULL

• WHERE Orders.id is NULL -> Orders.id가 NULL 값을 가진 데이터를 뽑는다.