How to display the Job groups having total salary greater than the maximum salary for managers?
SELECT job, SUM(sal)FROM empGROUP BY jobHAVING SUM(sal)> (SELECT MAX(sal) FROM emp WHERE job=’MANAGER’ );