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
1 answers ( 0 marked as helpful)
Hi Idrissa!
Thanks for reaching out.
Please accept my apologies for the delayed response.
Can you please clarify what your question is about, please? Thank you.
Looking forward to your answer.
Kind regards,
Martin