mAXMINUM salary aVG

select ID, Dept_name
  from employee a
  where a.salary > ( select
                           avg(b.salary)
                         from employee b
                         where b.Dept_name = a.Dept_name
                     )