SELECT job,deptno,grouping(deptno)"dept", SUM(sal)"sum" FROM emp where job NOT IN ('MANAGER', 'PRESIDENT' ) group by rollup(JOB,deptno) order by JOB,deptno