leetcode 1789

leetcode 1789

# Write your MySQL query statement below

select employee_id,department_id 
    from Employee 
    group by employee_id 
    having count(*)=1 
union 
select employee_id,department_id 
    from Employee 
    where primary_flag='Y';