Data Retrieval for the Assignement

Question

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

Answer 1

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

Submit an answer