Simple && Nested && Self Explanatory
\n# Code\n\n# Write your MySQL query statement below\nSELECT name \nFROM salesperson\nWHERE sales_id NOT IN (\n    SELECT sales_id \n    FROM orders\n    WHERE 
\n# Code\n```\n# Write your MySQL query statement below\nSELECT name \nFROM salesperson\nWHERE sales_id NOT IN (\n    SELECT sales_id \n    FROM orders\n    WHERE com_id = (\n        SELECT com_id\n        FROM company\n        WHERE name = "Red"\n    )\n)\n```
['MySQL']