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
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': 'Accounting', 'COUNT(*)': 2}, {'DEPARTMENT_NAME': 'Administration', 'COUNT(*)': 1}, {'DEPARTMENT_NAME': 'Executive', 'COUNT(*)': 3}, {'DEPARTMENT_NAME': 'Finance', 'COUNT(*)': 6}, {'DEPARTMENT_NAME': 'Human Resources', 'COUNT(*)': 1}, {'DEPARTMENT_NAME': 'IT', 'COUNT(*)': 5}, {'DEPARTMENT_NAME': 'Marketing', 'COUNT(*)': 2}, {'DEPARTMENT_NAME': 'Public Relations', 'COUNT(*)': 1}, {'DEPARTMENT_NAME': 'Purchasing', 'COUNT(*)': 6}, {'DEPARTMENT_NAME': 'Sales', 'COUNT(*)': 34}, {'DEPARTMENT_NAME': 'Shipping', 'COUNT(*)': 45}]