Mysql using Inner join and not in
\nselect\n    s.name\nfrom\n    SalesPerson s \nwhere\n    s.sales_id not in \n(select\n    sales_id \nfrom\n    Orders o\njoin\n    Company c\non\n    c.com_id
```\nselect\n    s.name\nfrom\n    SalesPerson s \nwhere\n    s.sales_id not in \n(select\n    sales_id \nfrom\n    Orders o\njoin\n    Company c\non\n    c.com_id = o.com_id\nwhere\n    c.name = \'RED\')\n```
['MySQL']