LeetCode - 183. Customers Who Never Order (MySQL)

Easy, SQL - Nested Query

RunTime : 869 ms

문제

Write a solution to find all customers who never order anything.

Return the result table in any order.

The result format is in the following example.

풀이

• 간단한 문제
• JOIN을 사용하는 것이 아닌 문제였다.

SELECT name AS Customers FROM Customers
WHERE id NOT IN
(
    SELECT customerId FROM Orders
)