TIL - 250610(leetcode_1개)

문제1(링크)

WITH cte AS (
    SELECT
        a.name
    FROM SalesPerson a
    LEFT JOIN Orders b
    ON a.sales_id = b.sales_id
    LEFT JOIN Company c
    ON b.com_id = c.com_id
)
SELECT name
FROM cte
WHERE name NOT IN (
    SELECT name
    FROM cte
    WHERE com_id = 1
)

비고 : NOT IN이 가능할 줄 몰랐는데 썼는데 됐다. 알아두자.