Easy to Understand | Joins + Subquery | Simple | MYSQL solution
\nselect\n   name \nfrom\n   salesperson \nwhere\n   sales_id not in \n   (\n      select\n         o.sales_id \n      from\n         company c \n         join\
```\nselect\n   name \nfrom\n   salesperson \nwhere\n   sales_id not in \n   (\n      select\n         o.sales_id \n      from\n         company c \n         join\n            orders o \n      where\n         c.com_id = o.com_id \n         and c.name = "RED"\n   )\n;\n\n\n```\n\n\n**I hope that you\'ve found the solution useful.**\n*In that case, please do upvote and encourage me to on my quest to document all leetcode problems\uD83D\uDE03*\nPS: Search for **mrmagician** tag in the discussion, if I have solved it, You will find it there\uD83D\uDE38
['MySQL']