Which of the following is correct to count the total salary in "deptno" wise where more than two employees exist?

Question

Which of the following is correct to count the total salary in " deptno " wise where more than two employees exist?

Answer

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) > 2

Answer

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2

Answer

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2

Answer

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) = 2

Crowdly