select name, salary, department from(

SELECT department,salary, name,

avg(salary)over(partition by department)

from employees ) as a

where salary > avg;