Sql query will be:
Select emp_name from Emp E1(Select dept_name,AVG(Salary) as A from Emp E2 Group by(dept_name))
where E1.salary>E2.A and E1.dept_name=E2.dept_name.
64.3k questions
77.9k answers
244k comments
80.0k users