select count(*) as "Nombre de lecteurs", type_abt_libelle as 'Type abonnement' from empr join type_abts on type_abt=id_type_abt WHERE empr_date_expiration BETWEEN "!!date1!!" and "!!date2!!" group by 2 order by 2