SELECT JOB, DEPTNO, AVG(SAL) AS "AVGSALARY" FROM EMP WHERE DEPTNO IN (10,20) AND SAL>2000 GROUP BY JOB, DEPTNO HAVING AVG(SAL)>2500 ...

select empid, salary as "Current Salary",salary*1.1 as "New Salary",salary*0.1 as "Incremented Amount" from empdetails ...