display the department name and number of employees in each of the department.
SELECT department_name ,  COUNT(*) FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id GROUP BY department_name
department name refers to department_name; number of employees in each department refers to COUNT(*); join condition for employees and departments tables refers to employees.department_id = departments.department_id;