1789-primary-department-for-each-employee.sql

# Write your MySQL query statement below
select employee_id , department_id
from employee
where primary_flag='Y'
group by employee_id
UNION
select employee_id , department_id
from employee
group by employee_id
having count(employee_id) =1