MySQL | Easy Solution
\n# Code\n\n# Write your MySQL query statement below\nSELECT DISTINCT sp.name\nFROM SalesPerson sp\nWHERE sp.sales_id NOT IN (\n    SELECT o.sales_id\n    FROM 
\n# Code\n```\n# Write your MySQL query statement below\nSELECT DISTINCT sp.name\nFROM SalesPerson sp\nWHERE sp.sales_id NOT IN (\n    SELECT o.sales_id\n    FROM Orders o\n    LEFT JOIN Company c ON o.com_id = c.com_id\n    WHERE c.name = \'RED\'\n);\n```
['MySQL']