SELECT department_name ,  COUNT(*) FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id GROUP BY department_name
What are the department names and how many employees work in each of them?
SELECT department_name , COUNT ( * ) FROM employees AS T1 JOIN departments AS T2 ON T1.department_id = T2.department_id GROUP BY department_name
select department_name , count ( * ) from employees as t1 join departments as t2 on t1 . department_id = t2 . department_id group by department_name
What are the department names and how many employees work in each of them ?