How many employees are there?
select count(*) from employees
Group these counts by department name.
select t2.department_name, count(*) from employees as t1 join departments as t2 on t1.department_id = t2.department_id group by t2.department_name