ms sql
```SQL\n/ Write your T-SQL query statement below /\n select name from salesperson \n except\n select a.name from orders c join salesperson a on c.sales_id = a.s
```SQL\n/* Write your T-SQL query statement below */\n select name from salesperson \n except\n select a.name from orders c join salesperson a on c.sales_id = a.sales_id\n join company b on c.com_id = b.com_id\n where b.name = \'RED\'
['MS SQL Server']