需要显示员工人数超过100人的部门名称。在雇员(employees)和部门(departments)这两个关系中,应使用哪种查询? ( )
Employee
---------
Empno
Employeename
Salary
Deptno
///////////////////////////////////
Department
---------
Deptno
Departname
Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100);
Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100);
Select departname from department where count(deptno) > 100;
Select departname from department where deptno in (select count(*) from employee where count(*) > 100);