Leet_sql_2_607. Sales Person

# Write your MySQL query statement below
Select s.name
from salesperson s
where s.name not in
(Select s.name
from salesperson s
left join orders o on s.sales_id=o.sales_id
left join company c on c.com_id=o.com_id
where c.name="red");