from 절에서 사용되는 뷰

select a.last_name, a.salary, a.department_id, b.maxsal

from employees a, (select department_id, max(salary) maxsal

                          from employees

                          group by department_id) b

where a.department_id = b.department_id

and a.salary<b.maxsal;