单项选择题

A.select deptno,job,sum(sal)from emp group by job,deptno;
B.select sum(sal),deptno,job from emp group by job,deptno;
C.select deptno,job,sum(sal)from emp;
D.select deptno,sum(sal),job from emp group by job,deptno;