[LeetCode][MySQL] Sales Person

https://leetcode.com/problems/sales-person/

Sales Person - LeetCode

 

select name
from salesperson
where sales_id not in (
    select sales_id
    from orders o
    left join company c
    on o.com_id = c.com_id
    where c.name = 'RED'
)

 

orders 테이블과 company 테이블을 조인하여 company name이 RED인 회사에서 주문한 sales_id를 추출하고,

NOT IN을 활용해 해당 sales_id를 제외하도록 했다.