Leetcode 1789. 员工的直属部门

题目

Leetcode 1789. 员工的直属部门

代码（7.22 首刷看解析）

having后面只能跟聚合函数！

此外，这里还用到了union，表示联合查询，可以把重复的去除，如果想要保留，则用union all

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