Q. Which of the following queries are legal? (Solved)
1. select deptno, count(deptno) from emp group by ename;
2. select deptno, count(deptno), job from emp group by deptno;
3. select deptno, avg(sal) from emp;
4. select deptno, avg(sal) from emp group by deptno;
- d. select deptno, avg(sal) from emp group by deptno;