Nama : Laura Meinina Sari Pinem
Nim : 6301120226
Kelas : DBD-12-01
1. select last_name from employees where last_name !=’Lorentz’ start with last_name=’Lorentz’ connect by prior manager_id=employee_id;
2. select e.last_name,e.salary,d.department_name from employees e join departments d on(e.department_id=d.department_id)start with e.last_name=’Mourgos’ connect by prior e.employee_id=e.manager_id;
3. select e.last_name,e.employee_id,e.manager_id,d.department_name from employees e join departments d on(e.department_id=d.department_id) where e.job_id!=’IT_PROG’ start with e.manager_id is null connect by prior e.employee_id=e.manager_id and e.last_name!=’De Hann’;
4.select e.last_name,e.employee_id,e.manager_id,d.department_name from employees e join departments d on(e.department_id=d.department_id) where last_name !=’Chen’ start with e.manager_id=(select manager_id from employees where last_name=’Chen’) connect by prior e.employee_id=e.manager_id;
5..select e.last_name,e.employee_id,e.manager_id,d.department_name,j.job_title from employees e join departments d on(e.department_id=d.department_id) join jobs j on
(e.job_id=j.job_id) where e.department_id=(select department_id from employees where last_name=’Zlotkey’) start with e.manager_id=(select manager_id from employees where
last_name=’Zlotkey’) connect by prior e.employee_id=e.manager_id;
6.select e.last_name,e.employee_id,e.manager_id,d.department_name,j.job_title from employees e join departments d on(e.department_id=d.department_id) join jobs j on
(e.job_id=j.job_id) where (d.department_id,j.job_id)=(select department_id,job_id from employees where last_name=’Vargas’) start with e.manager_id=(select manager_id from
employees where last_name=’Vargas’) connect by prior e.employee_id=e.manager_id;