perrocisww

dh
sdh
sd
hs
dh
sdh
dshsdhshsdhhds
hsd
hf
sdh
sdh

sd
h
h
--mostrar el apellido del empleado, el nombre de su cargo, el nombre de su departamento,
--para todos los trabajadores de"United States"
select last_name, department_name, job_title
from employees e
join departments d
on e.department_id = d.department_id
join jobs j
on e.job_id = j.job_id
join locations l
ond.location_id = l.location_id
join countries co
on l.country_id = co.country_id
where co.country_name like 'United States%';

--cambiar el anterior usando subconsulta
select last_name,department_name, job_title
from employees e
join departments d
on e.department_id = d.department_id
join jobs j
on e.job_id = j.job_id
where d.location_id in (select location_id from locations wherecountry_id in
(select country_id from countries where
country_name like 'United States%'));--EJERSUCIOS
select last_name, department_name
from employees, departments
where employees.department_id = departments.department_id(+);

--Mostrar el id delpais, el nombre del pais y el nombre de la region con un join natural.
select country_id, country_name, region_name
from countries
natural join regions;

--Mostrar el nombre, apellido, su jefe, id dedepartamento, codigo de la ubicacion,
--para todos los trabajadores de cargos que comiencen con SA, yse un using
select first_name, last_name, e.manager_id, department_id, location_id
fromemployees e
join departments d
using(department_id);

--mostrar el nombre y apellido del empleado y al apellido de su jefe, para todos
--los empleados de los departamentos 50,60,90
selecte.first_name, e.last_name, f.last_name as "JEFE"
from employees e
join employees f
on e.manager_id = f.employee_id
where e.department_id in (50,60,90);

--Mostrar el apellido del jefe y la cantidad de...