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


Success


```sql
/*
SELECT SalesPerson.name AS name from SalesPerson
WHERE SalesPerson.name NOT IN
(
  SELECT SalesPerson.name as name FROM 
  (
    (Orders JOIN Company on Orders.com_id = Company.com_id) 
    JOIN SalesPerson on Orders.sales_id = SalesPerson.sales_id AND Company.name = "RED"
  )
)
;
*/

SELECT SalesPerson.name AS name from SalesPerson
WHERE SalesPerson.name NOT IN
(
  SELECT SalesPerson.name as name FROM SalesPerson, Orders, Company
  WHERE Orders.com_id = Company.com_id AND Orders.sales_id = SalesPerson.sales_id AND Company.name = "RED"
)
;
```