607.销售员 https://leetcode.cn/problems/sales-person/description/ 分析:从一个表进行筛选,用where not in 进行限定,限定后是一个表关联。 select sp.name from SalesPerson as sp where sp.sales_id NOT IN ( select o.sales_id from Orders o left join Company c ON o.com_id=c.com_id where c.name='RED' )