Category Hierarchy

select employee_id, first_name, last_name, department_name, location_id
from employees as e, departments as d
where d.department_id = e.department_id and (location_id)
in 
(select location_id
from departments
where department_name = 'Finance')