SQL_CUBE_NOTIN_1.htm
Script:

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

ORACLE