3 Solutions - Subquery, NATURAL JOIN + NOT IN, NATURAL JOIN + NOT EXISTS
\nSELECT \n\tname \nFROM \n\tSalesPerson \nWHERE \n\tsales_id NOT IN (\n\t\tSELECT \n\t\t\tsales_id \n\t\tFROM \n\t\t\tOrders \n\t\tWHERE \n\t\t\tcom_id = (\n\t
```\nSELECT \n\tname \nFROM \n\tSalesPerson \nWHERE \n\tsales_id NOT IN (\n\t\tSELECT \n\t\t\tsales_id \n\t\tFROM \n\t\t\tOrders \n\t\tWHERE \n\t\t\tcom_id = (\n\t\t\t\tSELECT \n\t\t\t\t\tcom_id \n\t\t\t\tFROM \n\t\t\t\t\tCompany\n\t\t\t\tWHERE \n\t\t\t\t\tname = \'RED\' \n\t\t\t\t)\n\t\t)\n```\n\n```\nSELECT\n    s.name\nFROM\n    SalesPerson s\nWHERE\n    s.sales_id NOT IN (\n\t\tSELECT\n            o.sales_id\n        FROM\n            Orders o\n               NATURAL LEFT JOIN\n            Company c\n        WHERE\n            c.name = \'RED\'\n    )\n```\n\n```\nSELECT \n    s.name \nFROM \n    SalesPerson s\nWHERE \n    NOT EXISTS (\n\t\tSELECT \n\t\t\t*\n\t\tFROM   \n\t\t\tOrders o\n\t\t\t\tNATURAL LEFT JOIN\n\t\t\tCompany c\n\t\tWHERE\n\t\t\tc.name = \'RED\' AND s.sales_id = o.sales_id\n    )\n```\n\nIf you like the solutions, please upvote \uD83D\uDD3C\nFor any questions, or discussions, comment below. \uD83D\uDC47\uFE0F
[]