SQL/LeetCode

[LeetCode] 183. Customers Who Never Order

yeyeyep 2025. 2. 17. 17:27

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT c.name AS Customers
FROM Customers AS c
    LEFT JOIN Orders AS o ON c.id = o.customerID
WHERE o.id IS NULL