Sales Person Solution Mysql
Write your MySQL query statement below\nSELECT \n    s.name\nFROM\n    salesperson s\nWHERE\n    s.sales_id NOT IN (\n        SELECT\n            o.sales_id\n  
# Write your MySQL query statement below\nSELECT \n    s.name\nFROM\n    salesperson s\nWHERE\n    s.sales_id NOT IN (\n        SELECT\n            o.sales_id\n        FROM\n            orders o\n                LEFT JOIN\n            company c ON o.com_id = c.com_id\n        WHERE\n            c.name = \'RED\'\n    )
['MySQL']