|
1
2
3
4
5
6
7
8
9
10
|
# Write your MySQL query statement below
select s.name
from SalesPerson s
where s.name not in (
select s.name
from orders o
left join company c on o.com_id=c.com_id
left join SalesPerson s on o.sales_id =s.sales_id
where c.name ='RED'
)
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1050. Actors and Directors Who Cooperated At Least Three Times (0) | 2022.07.26 |
|---|---|
| leetcode 1084. Sales Analysis III (0) | 2022.07.18 |
| leetcode 1527. Patients With a Condition (0) | 2022.07.18 |
| leetcode 1729. Find Followers Count (0) | 2022.07.18 |
| leetcode 1141. User Activity for the Past 30 Days I (0) | 2022.04.02 |
댓글