[MySQL] Simple Solution || NOT IN
Please upvote if you find this solution useful! \u0AEE*,,\u02C3 \u1D55 \u02C2\u10D0\n\nSELECT name\nFROM SalesPerson\nWhere sales_id NOT IN (\nSELECT a.sales_id
Please upvote if you find this solution useful! \u0AEE*,,\u02C3 \u1D55 \u02C2\u10D0\n```\nSELECT name\nFROM SalesPerson\nWhere sales_id NOT IN (\nSELECT a.sales_id\nFROM Orders a JOIN Company b on a.com_id = b.com_id\nWHERE b.name = \'RED\')\n```
['MySQL']