力扣---高频SQL题---31---1789. 员工的直属部门

一、题目

二、代码

# Write your MySQL query statement below
#超过一个时  需要决策 无法决策则不输出

-- union
-- select employee_id, department_id  from Employee
-- where  primary_flag = 'Y' 




select employee_id , department_id from Employee 
where employee_id not in
(
    select employee_id  from Employee
    where  primary_flag = 'Y' 
)
group by employee_id
having count(distinct department_id) = 1
union
select employee_id, department_id  from Employee
where  primary_flag = 'Y' 

三、运行结果