select libelle_categorie as Catégorie, count(arc_id) as Total from pret_archive join notices_categories on arc_expl_notice=notcateg_notice join categories on notices_categories.num_noeud=categories.num_noeud where year(arc_debut)=!!choixannee!! and categories.num_noeud=!!choixcateg!! group by 1