[LeetCode] 607. Sales Person

 

 

[문제]

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

 

 

[MySQL]

WITH company_red AS (
    SELECT s.name
    FROM Orders AS o
        LEFT JOIN SalesPerson AS s ON o.sales_id = s.sales_id
        LEFT JOIN Company AS c ON o.com_id = c.com_id
    WHERE c.name = 'RED'
)

SELECT name
FROM SalesPerson
WHERE name NOT IN (SELECT name
                    FROM company_red)