Begineer Friendly || SQL || simplest
\n# Code\nmysql []\n# Write your MySQL query statement below\nselect t1.name \nfrom SalesPerson t1\nwhere t1.sales_id not in (\n    select t3.sales_id \n    fro
\n# Code\n```mysql []\n# Write your MySQL query statement below\nselect t1.name \nfrom SalesPerson t1\nwhere t1.sales_id not in (\n    select t3.sales_id \n    from Company t2 join Orders t3\n    on t2.com_id = t3.com_id and t2.name = "RED"\n)\n```
['Database', 'MySQL']