[MySQL] || Simple Solution || Without Join
\n\nselect name from SalesPerson where \nsales_id not in (select sales_id from Orders where\ncom_id in (select com_id from Company where name = \'RED\'));\n
```\n\nselect name from SalesPerson where \nsales_id not in (select sales_id from Orders where\ncom_id in (select com_id from Company where name = \'RED\'));\n```
['MySQL']