MOST EASY WAY TO SOLVE THIS PROBLEM USING SUBQUERRY!
IntuitionPLEASE UPVOTE!
ApproachComplexity
Time complexity:

Space complexity:
Code
# Intuition
PLEASE UPVOTE!
![images.jpeg](https://assets.leetcode.com/users/images/5765ca05-9647-4425-aa51-bf28181eff94_1741526780.4734123.jpeg)
<!-- Describe your first thoughts on how to solve this problem. -->

# Approach
<!-- Describe your approach to solving the problem. -->

# Complexity
- Time complexity:
<!-- Add your time complexity here, e.g. $$O(n)$$ -->

- Space complexity:
<!-- Add your space complexity here, e.g. $$O(n)$$ -->

# Code
```postgresql []
-- Write your PostgreSQL query statement below
SELECT DISTINCT s.name AS  name
FROM SalesPerson s
LEFT JOIN Orders o
ON s.sales_id = o.sales_id
WHERE s.sales_id NOT IN 
(SELECT o.sales_id
FROM Orders o
LEFT JOIN Company c
ON o.com_id = c.com_id
WHERE c.name LIKE 'RED')
```
['Database', 'MySQL', 'Oracle', 'MS SQL Server', 'PostgreSQL']