Year-over-Year Comparison

Write a SQL query to compare employee counts hired in each year.

Expected Columns

• hire_year
• employees_hired

Example Output

| hire_year | employees_hired | |-----------|-----------------| | 2016 | 1 | | 2017 | 1 | | 2018 | 2 | | 2019 | 3 | | 2020 | 3 | | 2021 | 2 | | 2022 | 2 | | 2023 | 1 |