A) Select AVG (sal) from emp GROUP BY deptno HAVING COUNT (empno)\[>2;\]
B) Select AVG (sal) from emp where COUNT>2;
C) Select AVG (sal) from emp GROUP BY (empno) where COUNT \[>2;\]
D) Select AVG (sal) from emp GROUP BY (empno) AND COUNT\[>2;\]
Correct Answer: A
You need to login to perform this action.
You will be redirected in
3 sec