Three Simple and Easy Accepted solution Using MINUS, NOT EXISTS & NOT IN
first solution\n\n\nSELECT name \nFROM salesperson\nWHERE name NOT IN\n               (\n               SELECT s.name as name\n                   FROM salespers
# first solution\n```\n\nSELECT name \nFROM salesperson\nWHERE name NOT IN\n               (\n               SELECT s.name as name\n                   FROM salesperson s, company c, orders o\n                        WHERE s.sales_id = o.sales_id     AND\n                               c.com_id = o.com_id       AND\n                                c.name = \'RED\');\n               \n```\n\n# Second solution\n```\nselect name from salesperson\nminus\nselect s.name\nfrom SalesPerson s,Company c, Orders o\nwhere o.com_id=c.com_id and  o.sales_id=s.sales_id and c.name=\'RED\';\n```\n\n# Third solution\n```\nSELECT   s.name as name\nFROM    salesperson s\nWHERE   NOT EXISTS (\n    SELECT  s.name \n    FROM    company c, orders o\n    WHERE   s.sales_id = o.sales_id \n        AND c.com_id = o.com_id\n        AND c.name = \'RED\'\n    );\n```
['Oracle']