the names of those departments where there are more than 100 employees..., SQL, Databases

Test
- Model Test
Index

Question:The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used?
Employee
---------
Empno
Employeename
Salary
Deptno

Department
---------
Deptno
Departname

A Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100); 
B Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100); 
C Select departname from department where count(deptno) > 100; 
D Select departname from department where deptno in (select count(*) from employee where count(*) > 100);

/98

+ AnswerA

+ Report

Descriptive on SQL Ebook

Total Preview: 14562

Question:The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Employeename Salary Deptno Department --------- Deptno Departname

A Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100);

B Select departname from department where deptno in (select count() from employee group by deptno where count() > 100);

C Select departname from department where count(deptno) > 100;

D Select departname from department where deptno in (select count() from employee where count() > 100);

A