Clase de hoy: Resolvimos el problema de la clase pasada. [Parte 1]

Select department_id, count(*) as "total empleados"
from employees
group by department_id

desc departments

DEPARTMENT_NAME

Select DEPARTMENT_NAME as "Departamento", count(*) as "total empleados"
from employees, departments
group by DEPARTMENT_NAME

Select DEPARTMENT_NAME as "Departamento", count(*) as "total empleados"
from employees e, departments d
where e.department_id = d.department_id
group by DEPARTMENT_NAME


Select DEPARTMENT_NAME, count(Employee_id)
from employees e, departments d
where e.department_id = d.department_id
having count (Employee_id)>2
group by department_name
order by department_name


Select department_id, count(*) as "total empleados"
from employees
group by department_id
order by department_id