dokuwiki

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')