Clase 12 de Mayo

--practicando uso de join--

desc employees;
desc departments;

select e.first_name, e.last_name, d.department_id, d.department_name
from employees e, departments d
where e.department_id = d.department_id;

select e.first_name, e.last_name, d.department_id, d.department_name
from employees e join departments d on
(d.department_id = e.department_id)
order by department_id;

select d.department_id, count (*)
from employees e join departments d on
(d.department_id = e.department_id)
group by d.department_id
order by department_id;