一、题目
二、代码
# 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'