For each year, show the total no of employees who were hired during that year from the employees table

SELECT YEAR(HIRE_DATE),

    COUNT(EMPLOYEE_ID) AS "NO of Employee"

FROM employees

GROUP BY YEAR(HIRE_DATE);