Simple MySQL solution with 83% faster
\n\nwith cte as\n(select sales_id \nfrom Orders o \nleft join Company c\non o.com_id = c.com_id\nwhere c.name like \'RED\')\n\nselect name \nfrom SalesPerson\nw
\n```\nwith cte as\n(select sales_id \nfrom Orders o \nleft join Company c\non o.com_id = c.com_id\nwhere c.name like \'RED\')\n\nselect name \nfrom SalesPerson\nwhere sales_id not in(select distinct sales_id from cte)\n```\n![upv.jpeg](https://assets.leetcode.com/users/images/d4484e7e-efc7-47c0-9b12-5de672b7aba6_1691063727.8374465.jpeg)\n
['MySQL']