Which_of_the_following_queries_are_legal?$

Question

TuteeHUB · Accepted Answer

SELECT deptno, avg(sal) FROM emp;

TuteeHUB · Answer

SELECT deptno, count(deptno) FROM emp GROUP BY ename;

TuteeHUB · Answer

SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;

TuteeHUB · Answer

SELECT deptno, avg(sal) FROM emp GROUP BY deptno;

1.	Which_of_the_following_queries_are_legal?$
A.	SELECT deptno, count(deptno) FROM emp GROUP BY ename;
B.	SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;
C.	SELECT deptno, avg(sal) FROM emp;
D.	SELECT deptno, avg(sal) FROM emp GROUP BY deptno;
Answer» C. SELECT deptno, avg(sal) FROM emp;

Discussion