Basis Data Modul 7 (Query)

select location_id, street_address, city, state_province, country_name
from locations
natural join countries;

select e.last_name, department_id, d.department_name
from employees e JOIN departments d
using(department_id);

select e.last_name, e.department_id, d.department_id,
d.department_name
from employees e JOIN departments d
ON(e.department_id = d.department_id);

select last_name, job_id, department_id, department_name
from employees
natural join departments
where location_id = 1800;

select e.last_name, e.job_id, department_id, d.department_name
from employees e join departments d
using(department_id)
where location_id = 1800;

select e.last_name, e.job_id, e.department_id, d.department_id,
d.department_name
from employees e join departments d
on(e.department_id = d.department_id)
where location_id = 1800;

select e.last_name, e.employee_id EMP#, m.last_name,
m.manager_id Mgr#
from employees e join employees m
on(e.manager_id = m.employee_id);

select e.last_name, d.department_name, d.location_id,
l.location_id, l.city
from departments d
join employees e
on e.department_id = d.department_id
join locations l
on d.location_id = l.location_id
where commission_pct is not null;