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