Count Employees Hired Per Month Grouping

Question

Find the number of employees hired in each month.

Accepted Answer

```sql
SELECT MONTH(hire_date) AS hire_month, COUNT(*) AS employee_count
FROM employees
GROUP BY MONTH(hire_date);
```

This query groups the records from the "employees" table by the month extracted from the "hire_date" column and calculates the total count of employees for each respective month.