MOST SIMPLE WAY
ApproachIN SUB QUERY I FETCH THOSE ID, WHICH ARE RELATED TO COMPANY RED. IN MAIN I JUST OPIT THEM AND PRINT REST NAMES FROM SALES PERSON TABLE.Complexity
Time c

# Approach
<!-- Describe your approach to solving the problem. --> 
IN SUB QUERY I FETCH THOSE ID, WHICH ARE RELATED TO COMPANY RED. IN MAIN I JUST OPIT THEM AND PRINT REST NAMES FROM SALES PERSON TABLE.

# Complexity
- Time complexity:
<!-- Add your time complexity here, e.g. $$O(n)$$ -->

- Space complexity:
<!-- Add your space complexity here, e.g. $$O(n)$$ -->

# Code
```mssql []
/* Write your T-SQL query statement below */
SELECT name  FROM SalesPerson 
WHERE sales_id  NOT IN (
        SELECT sales_id
        FROM Orders  O JOIN Company C
        ON O.com_id  = C.com_id  AND C.NAME = 'RED')
```
['MS SQL Server']