NAMA : MAYYANI PUSPITASARI SIALLAGAN
KELAS : DBD-12-01
NIM : 6301120186
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;