查询人数最多的部门的信息

select *
  from departments
 where departmentid in
       (select departmentid
          from employees
         group by departmentid
        having count(*) >= ALL (select count(*)
                                 from employees
                                group by departmentid));