Query To Find Maximum, Minimum and Average Salary department-wise || SQL Interview Question

[maheshtiwari]

SELECT department, MAX(salary) OVER (PARTITION BY department) AS max_salary,
MIN(salary) OVER (PARTITION BY department) AS min_salary,
AVG(salary) OVER (PARTITION BY department) AS avg_salary
FROM employee;