select distinct s.name
from salesperson as s
where s.sales_id not in
(select distinct o.sales_id from orders as o where o.com_id in(
select c.com_id from company as c where c.name = 'Red'
));
select distinct s.name
from salesperson as s
where s.sales_id not in
(select distinct o.sales_id from orders as o where o.com_id in(
select c.com_id from company as c where c.name = 'Red'
));