求这个sql怎么写？

Question

求出员工性别为1并且数量大于2的部门名称

Answer 1

select * from departments where ID in(

 SELECT departmentid 
FROM employees where sex=1 group by departmentid having COUNT(*)>1)