SELECT COU_ANNEE AS "Annee", PER_GENRE AS
"Genre (Catégorie)", COUNT(per_id) AS "Nombre Candidats"
FROM cc_personne
JOIN cc_course ON COU_PER_ID = PER_ID
WHERE PER_EQU_ID = (SELECT EQU_ID
FROM cc_equipe
WHERE EQU_NOM = "HES-SO Genève")
GROUP BY COU_ANNEE, COU_COURSE