[Accepted] MySQL
\nselect name\nfrom salesperson\nwhere sales_id not in (\n    select sales_id\n    from orders\n    left join company using(com_id)\n    where orders.sales_id =
```\nselect name\nfrom salesperson\nwhere sales_id not in (\n    select sales_id\n    from orders\n    left join company using(com_id)\n    where orders.sales_id = salesperson.sales_id and company.name = "RED"\n)\n```
['MySQL']