SELECT job,deptno,round(avg(sal),2 ) "avg", SUM(sal)"sum" FROM emp where job NOT IN ('MANAGER', 'PRESIDENT' )GROUP BY cube(job,deptno) ORDER BY job,deptno