SQL Server
\nselect name from salesperson s where s.name not in (\n\t\tSelect s.name from salesperson s inner join orders o on s.sales_id = o.sales_id\n\t\tinner join comp
```\nselect name from salesperson s where s.name not in (\n\t\tSelect s.name from salesperson s inner join orders o on s.sales_id = o.sales_id\n\t\tinner join company c on c.com_id = o.com_id where c.name = \'Red\' \n) \n```
[]