607. 销售员
方法1:嵌套连接
# Write your MySQL query statement below
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'
)
)
方法2:全连接
# Write your MySQL query statement below
select name
from SalesPerson
where sales_id not in (
(select sales_id
from Orders join Company ON Orders.com_id=Company.com_id
where Company.name='RED'
)
)