This is an old revision of the document!
select avg(salary) from employees e, departments d where d.department_id = e.department_id and department_name = 'IT' select first_name, last_name, salary from employees where salary > 5760 select first_name, last_name, salary from employees e where salary > (select avg(salary) from employees e, departments d where d.department_id = e.department_id and department_name = 'IT')