607. Sales Person mysql

https://leetcode.com/problems/sales-person/?envType=study-plan&id=sql-i 

Sales Person - LeetCode

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

조인문 여러 개 쓰는 거 조금 익숙해진 것 같다 ㅎ ㅎ