Beats 98.8% of the solution using left join and not in 
\nSELECT s.NAME \nFROM   salesperson s \nWHERE  sales_id NOT IN(SELECT sales_id \n                       FROM   orders o \n                              LEFT JO
```\nSELECT s.NAME \nFROM   salesperson s \nWHERE  sales_id NOT IN(SELECT sales_id \n                       FROM   orders o \n                              LEFT JOIN company c \n                                     ON o.com_id = c.com_id \n                       WHERE  c.NAME = \'RED\') \n```
[]