How to display employee name and his salary whose salary is greater than highest average of department number?
SELECT ename,deptno,sal FROM emp WHERE sal> (SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno );