Easy Solution to find SalesPerson without RED company Order, Faster then 82%, Works for all
Intuition\n Describe your first thoughts on how to solve this problem. \n\n# Approach\n Describe your approach to solving the problem. \nfind Sales_id of the sa
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\nfind Sales_id of the sales person having Orders of Red Company, from join of Company and Orders, then filter out the salesperson which are not in this list\n\n# Complexity\n- Time complexity: 867 ms (faster then 82% solutions submitted)\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```\n/* Write your PL/SQL query statement below */\nSELECT s.name\nFROM SalesPerson s\nWHERE sales_id NOT IN (\n    SELECT o.sales_id\n    FROM Company c, Orders o\n    WHERE o.com_id = c.com_id\n    AND c.name = \'RED\')\n```\nIt works in MySQL, MS SQL Server, Oracle
['MySQL', 'Oracle', 'MS SQL Server']