Very Simple || SQL Basics ||✅✔✅✔
\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN \n     (\n         SELECT sales_id FROM orders WHERE com_id in (SELECT com_id from company where name = "
```\nSELECT name\nFROM salesperson\nWHERE sales_id NOT IN \n     (\n         SELECT sales_id FROM orders WHERE com_id in (SELECT com_id from company where name = "RED")\n     );\n```\n\nVery simple to understand\nAsk if any doubt persists :)\n\n^ _upvote_^\n\n
['MySQL']