Easy and Simple Solution Using Join and Sub Query
\n/* WRITE YOUR T-SQL QUERY STATEMENT BELOW */\nSELECT NAME FROM SALESPERSON WHERE SALES_ID NOT IN(\nSELECT S.SALES_ID FROM SALESPERSON S RIGHT JOIN ORDERS O ON
```\n/* WRITE YOUR T-SQL QUERY STATEMENT BELOW */\nSELECT NAME FROM SALESPERSON WHERE SALES_ID NOT IN(\nSELECT S.SALES_ID FROM SALESPERSON S RIGHT JOIN ORDERS O ON S.SALES_ID = O.SALES_ID  JOIN COMPANY C ON O.COM_ID = C.COM_ID \nWHERE C.NAME = \'RED\')\n```
['MySQL']