No subquery, simple select from where with left join:)
\nselect s.name from SalesPerson s\nleft join (Orders o join Company c on (o.com_id = c.com_id and c.name=\'RED\') )\non s.sales_id=o.sales_id where o.sales_id 
```\nselect s.name from SalesPerson s\nleft join (Orders o join Company c on (o.com_id = c.com_id and c.name=\'RED\') )\non s.sales_id=o.sales_id where o.sales_id is null;\n```
['MySQL']