TUGAS PERTEMUAN-6 SPBD

mencari first_name, last_name,salary :
select first_name,last_name,salary,employees.department_id,department_name
from employees,departments
where departments.department_id=employees.department_id;

menampilkan first_name,last_name, department_name, salary, job_title:
select first_name,last_name,salary,department_name,job_title
from employees,departments,jobs
where employees.department_id=departments.department_id
and employees.job_id=jobs.job_id;

menampilkan region_name, country_name, street_addres, city:
select region_name,country_name,street_adress,city
from regions,countries,locations
where regions.region_id=countries.region_id and
locations.co=countries.co;