Easy
\n\n# Code\nmysql []\nselect s.name from SalesPerson s\nwhere s.sales_id NOT in (\n    select o.sales_id \n    from Orders o\n    left join Company c\n    on o.
\n\n# Code\n```mysql []\nselect s.name from SalesPerson s\nwhere s.sales_id NOT in (\n    select o.sales_id \n    from Orders o\n    left join Company c\n    on o.com_id = c.com_id\n    where o.com_id = c.com_id and c.name = \'RED\'\n);\n```
['Database', 'MySQL']