Apr 2, 2023
select name from(
SELECT name, salary, avg(salary)over( partition by department)
from employees )as a
where salary > avg;
select name from(
SELECT name, salary, avg(salary)over( partition by department)
from employees )as a
where salary > avg;
