Count Employees Hired Per Each Year

Question

Find the number of employees hired in each year.

Accepted Answer

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

This query extracts the year from the "hire_date" column and counts the total number of records grouped by each year.