Task: Text to Code
Input (English): What are the department names and how many employees work in each of them?
Output (English): SELECT department_name ,  COUNT(*) FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id GROUP BY department_name