MySQL Easy Implementation
\nSELECT name\nFROM salesPerson\nWHERE  sales_id NOT IN\n    (\n        SELECT o.sales_id\n        FROM orders o \n        LEFT JOIN company c\n        ON o.com
```\nSELECT name\nFROM salesPerson\nWHERE  sales_id NOT IN\n    (\n        SELECT o.sales_id\n        FROM orders o \n        LEFT JOIN company c\n        ON o.com_id = c.com_id    \n        WHERE c.name = \'RED\'\n    )\n\t```
['MySQL']