select deptno,job,sum(sal) from emp group by deptno,job order by deptno;