Write a query to display the difference of highest and lowest salary of each department having

Q. Write a query to display the difference of highest and lowest salary of each department having maximum salary > 4000.

Answer =

SELECT MAX (sal) - MIN (sal) "Difference" FROM empl
GROUP BY deptno
HAVING MAX (sal) > 40003;