Nama : Margaretha Amanda
Kelas : DBD-12-01
NIM :6301124024
1. select last_name from employees
where last_name !=’Lorentz’
start with last_name=’Lorentz’
connect by prior manager_id=employee_id;
2. select last_name, salary, department_name
from employees e join departments d
on (e.department_id=d.department_id)
start with last_name=’Mourgos’
connect by prior 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 Haan’;
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 departments d join employees e
on (d.department_id=e.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 departments d join employees e
on (d.department_id=e.department_id) join jobs j
on (e.job_id=j.job_id)
where (e.department_id,e.job_id) in (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.manager_id=e.employee_id;
LIHAT SOAL KLIK