SELECT CASE WHEN section_libelle IS NULL THEN " Section supprimée" ELSE section_libelle END as Section, count(*) as "Nombre de prêts" FROM pret_archive LEFT JOIN docs_section ON idsection = arc_expl_section where year(arc_debut) = '!!param1!!' group by arc_expl_section order by Section