[SQL] LeetCode : LEFT JOIN 문제

183. Customers Who Never Order

 

문제

 

Write an SQL query to report all customers who never order anything.

Return the result table in any order.

 

풀이

 

SELECT customers.name AS Customers
FROM customers 
    LEFT JOIN orders ON customers.id = orders.customerid 
WHERE orders.id IS NULL