What are the different department names?
select department_name from departments
How many employees work in each one?
select department_name, count(*) from employees as t1 join departments as t2 on t1.department_id = t2.department_id group by department_name