Data Retrieval for the Assignement

Select 
year(hire_date) as calendar_year,
gender,
count(emp_no) as num_of_employees

from t_employees
group by calendar_year,gender

order by calendar_year