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
Total number of employees in each department D1 and D2
2
Total number of employees of department D1 and D2 if their total is > 5
3
Display total number of employees in both departments Dl and D2
4
The output of the query must have atleast two rows