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