How to display employee records who gets more salary than the average salary in the department?

Question

Q. How to display employee records who gets more salary than the average salary in the department?

Answer 1

Ans is:- 

Select * from employee where salary>(select avg(salary) from dept, employee where dept.deptno = employee.deptno;