LeetCode--607. 销售员

解题思路

先找出向RED销售的员工

然后not in 就是没向RED销售的

select name from salesperson where sales_id not in ( select sales_id from orders where com_id in (select com_id from company where name = 'RED') )