FASTER THAN 99% MS SQL SOLUTION NO JOINS
\nSELECT name FROM\nSalesPerson \nWHERE sales_id not in(select sales_id FROM Orders\n                     where com_id=(select com_id from Company where name =\
```\nSELECT name FROM\nSalesPerson \nWHERE sales_id not in(select sales_id FROM Orders\n                     where com_id=(select com_id from Company where name =\'RED\'))\n\t\t\t\t\t ```
['MySQL', 'MS SQL Server']