Beat 99.13% simple solution
Intuition\n\n\n\n# Code\n\nSELECT name \nFROM SalesPerson\nWHERE sales_id NOT IN (\n    SELECT sales_id \n    FROM Orders o \n    JOIN Company c ON o.com_id = c
# Intuition\n![image.png](https://assets.leetcode.com/users/images/0c287222-9c8c-4ccc-903c-9d33de4dced5_1718452731.9480557.png)\n\n\n# Code\n```\nSELECT name \nFROM SalesPerson\nWHERE sales_id NOT IN (\n    SELECT sales_id \n    FROM Orders o \n    JOIN Company c ON o.com_id = c.com_id AND c.name = \'RED\'\n)\n```
['PostgreSQL']