SQL Server CLEAN & EASY
\nSELECT DISTINCT sp.name\nFROM SalesPerson sp\nLEFT JOIN Orders o ON sp.sales_id = o.sales_id\nWHERE sp.sales_id NOT IN (\n  SELECT DISTINCT o.sales_id\n  FROM
```\nSELECT DISTINCT sp.name\nFROM SalesPerson sp\nLEFT JOIN Orders o ON sp.sales_id = o.sales_id\nWHERE sp.sales_id NOT IN (\n  SELECT DISTINCT o.sales_id\n  FROM Orders o\n  INNER JOIN Company c ON o.com_id = c.com_id\n  WHERE c.name = \'RED\'\n);\n\n```
[]