Two easy solution one using only subquery and other using subquery with join.
Intuition\n Describe your first thoughts on how to solve this problem. \n\n# Approach\n Describe your approach to solving the problem. \n\n# Complexity\n- Time 
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\n\n# Complexity\n- Time complexity:\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\n\n- Space complexity:\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n- ORACLE\n```\n/* Write your PL/SQL query statement below */\nSELECT NAME\nFROM SALESPERSON\nWHERE SALES_ID NOT IN (SELECT SALES_ID\n                        FROM ORDERS\n                        WHERE COM_ID IN (SELECT COM_ID\n                                            FROM COMPANY\n                                            WHERE NAME IN \'RED\'));\n```\n# Code\n- MySQL\n```\n# Write your MySQL query statement below\nSELECT sp.name\nFROM SalesPerson sp\nWHERE sp.name NOT IN(\n    SELECT sp.name\n    FROM SalesPerson sp\n        LEFT JOIN Orders o ON sp.sales_id = o.sales_id\n        LEFT JOIN Company c ON o.com_id = c.com_id\n    WHERE c.name = \'Red\'\n);\n```
['MySQL', 'Oracle']