select location_id, street_address, city, state_province, COUNTRY_NAME
from locations
natural join COUNTRIES;


select last_name, department_id, department_name
from employees
natural join departments;



select e.last_name, e.job_id, d.department_id, d.department_name
from employees e
join departments d
on(e.department_id = d.department_id)
join locations l
on(l.location_id = d.location_id)
where l.city='Toronto';