MS SQL Server (6 Line Solution)
\nselect name\nfrom SalesPerson\nwhere sales_id NOT IN (select sales_id\n                from Orders\n                where com_id IN (select com_id\n          
```\nselect name\nfrom SalesPerson\nwhere sales_id NOT IN (select sales_id\n                from Orders\n                where com_id IN (select com_id\n                            from Company\n                            where name=\'RED\'))\n```
[]