select case when arc_empr_sexe='1' then 'Hommes' when arc_empr_sexe='2' then 'Femmes' else 'Non renseigné' end as Sexe, count(arc_id) as Nombre from pret_archive where year(arc_debut)=!!choixannee!! group by 1 order by 1