SELECT CASE WHEN  (!!param1!! - empr_year) <= 13 THEN ' Jusque 13 ans' WHEN (!!param1!! - empr_year) >13 and (!!param1!! - empr_year)<=24 THEN '14 à 24 ans' WHEN (!!param1!! - empr_year)>24 and (!!param1!! - empr_year)<=59 THEN '25 à 59 ans' WHEN (!!param1!! - empr_year)>59 THEN '60 ans et plus'  ELSE 'erreur sur age' END as "Tranche d'âge", count(*) as Nombre from empr where empr_categ in (!!categorie!!) and (year(empr_date_expiration)=!!param1!! or year(empr_date_adhesion)=!!param1!!) group by 1