Task Hierarchical Retrieval Solutions

Nama: Hesti Anna Elisabeth
NIM:6301120171
Kelas:DBD1201
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 adn e.last_name !=’De Hann’;
4.
5.