Solution
Code\npostgresql []\n-- Write your PostgreSQL query statement below\nSELECT s.name\nFROM SalesPerson s\nWHERE s.sales_id NOT IN (\n    SELECT o.sales_id\n    FR
# Code\n```postgresql []\n-- Write your PostgreSQL query statement below\nSELECT s.name\nFROM SalesPerson s\nWHERE s.sales_id NOT IN (\n    SELECT o.sales_id\n    FROM Orders o\n    JOIN Company c\n    ON o.com_id = c.com_id\n    WHERE c.name = \'RED\'\n);\n```
['PostgreSQL']