Find Month With Highest Employee Hires

Question

Find the month with the highest number of employee hires.

Accepted Answer

```sql
SELECT MONTH(hire_date) AS hire_month, COUNT(*) AS total_hires
FROM employees
GROUP BY hire_month
ORDER BY total_hires DESC
LIMIT 1;
```

This query extracts the month from the `hire_date` column, counts the number of occurrences for each month, and returns the month with the highest count by ordering the results in descending order and limiting the output to the top record.