MySQL | Simple Only Sub-Query Solution |
Code\n\nselect  name from salesperson where sales_id not in (\n    select sales_id from orders where com_id in \n        (select com_id from company where name 
# Code\n```\nselect  name from salesperson where sales_id not in (\n    select sales_id from orders where com_id in \n        (select com_id from company where name = "RED")\n)\n```
['MySQL']