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;