simple and easy oracle solution
\n(select s.name \nfrom SalesPerson s)\nminus\n(select distinct s.name\nfrom SalesPerson s,Company c, Orders o\nwhere o.com_id=c.com_id and  o.sales_id=s.sales_
```\n(select s.name \nfrom SalesPerson s)\nminus\n(select distinct s.name\nfrom SalesPerson s,Company c, Orders o\nwhere o.com_id=c.com_id and  o.sales_id=s.sales_id and c.name=\'RED\');\n```\n
['Oracle']