Ans:
SELECT e.*, (SELECT sum(sal) FROM emp e1 WHERE e1.deptno = e.deptno) SumSal_DeptWise,
round((SELECT avg(sal) FROM emp WHERE job = e.job), 2) AvgSal_JobWise,
(SELECT max(sal) FROM emp WHERE WHERE = e.deptno AND sal NOT IN (SELECT max(sal) FROM emp WHERE WHERE = e.deptno)) HighSal_2nd_DeptWise,
(SELECT min(sal) FROM emp WHERE job = e.job) LowSal_JobWise,
(SELECT m.ename FROM emp m WHERE e.mgr = m.empno) Manager
FROM emp e;