NOT IN subquery + Left JOIN
\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN (\n    SELECT sales_id\n    FROM orders LEFT JOIN company \n    ON orders.com_id = company.com_id\n    WH
```\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN (\n    SELECT sales_id\n    FROM orders LEFT JOIN company \n    ON orders.com_id = company.com_id\n    WHERE company.name = 'RED'\n)\nORDER BY name\n```
[]