#607 Sales Person

https://leetcode.com/problems/sales-person/

MS SQL Server

SELECT name 
FROM SalesPerson 
WHERE sales_id NOT IN (SELECT sales_id 
                       FROM Orders 
                       WHERE com_id = (SELECT com_id 
                                       FROM Company
                                       WHERE name = 'RED'))