No subquery, simple select from where with right join:)
select salesperson.name\n    from orders o join company c on (o.com_id = c.com_id and c.name = 'RED')\n    right join salesperson on salesperson.sales_id = o.sa
    select salesperson.name\n    from orders o join company c on (o.com_id = c.com_id and c.name = 'RED')\n    right join salesperson on salesperson.sales_id = o.sales_id\n    where o.sales_id is null
[]