Two Accepted Solutions
Approach 1:\n\nSELECT name from salesperson\nwhere sales_id not in \n(\n    select sales_id from orders where com_id in \n\t(select com_id from company where na
Approach 1:\n```\nSELECT name from salesperson\nwhere sales_id not in \n(\n    select sales_id from orders where com_id in \n\t(select com_id from company where name=\'RED\')\n)\n```\nApproach 2:\n```\nSELECT name FROM salesperson\nwhere sales_id not in\n(SELECT sales_id FROM orders\nLEFT JOIN\ncompany \nON orders.com_id=company.com_id \nWHERE company.name=\'RED\')\n```
[]