JOIN + NOT IN
SQL\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN (\n  SELECT DISTINCT sales_id\n  FROM orders \n  JOIN company USING(com_id)\n  WHERE name = \'RED\'\n)
```SQL\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN (\n  SELECT DISTINCT sales_id\n  FROM orders \n  JOIN company USING(com_id)\n  WHERE name = \'RED\'\n)\n\n```\n\n\n\n
['MySQL']