SELECT job,deptno,round(avg(sal),2 ) "avg", SUM(sal)"sum" FROM emp where job != 'PRESIDENT' GROUP BY ROLLUP(job,deptno) ORDER BY job,deptno