Given two tables EMPLOYEE (EID, ENAME, DEPTNO) DEPARTMENT (DEPTNO, DEPTNAME) Find the most appropriate statement of the given query : Select count (*) 'total' from EMPLOYEE where DEPTNO IN (D1, D2) group by DEPTNO having count (*) > 5.

1. ATotal number of employees in each department D1 and D2
2. BTotal number of employees of departments D1 and D2 if their total is > 5.
3. CDisplay total number of employees in both departments D1 and D2
4. DThe output of the query must have atleast two rows

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: B. Total number of employees of departments D1 and D2 if their total is > 5.

Explanation

The query counts employees per department D1 and D2 and keeps only departments whose count exceeds 5.