select empr_ville as Ville, count(*) as Nbre from empr where empr_categ in (!!categorie!!) and (year(empr_date_adhesion)=!!annee!! or year(empr_date_expiration)=!!annee!! or (year(empr_date_expiration)>=!!annee!! and year(empr_date_adhesion)<=!!annee!!)) group by empr_ville with rollup