with meilleures_nb_sorties as (
	select distinct A.region_niv1 as ABSCISSE, avg(nb_sortie_meilleure_saison) as TOTAL
	 from ci.pre_enquete_village A inner join ci.liste_site using (no_enquete) inner join
	ci.v_liste_menage using(no_site) where date_enquete_m is not null
	and nb_sortie_meilleure_saison>0 and nb_sortie_meilleure_saison<=7
        group by  A.region_niv1
	order by TOTAL desc
	) ,
	 moinsbonne_nb_sorties as
	(
	select distinct A.region_niv1 as ABSCISSE, avg(nb_sortie_moins_bonne_saison) as TOTAL
	 from ci.pre_enquete_village A inner join ci.liste_site using (no_enquete) inner join
	ci.v_liste_menage using(no_site) where date_enquete_m is not null
	and nb_sortie_moins_bonne_saison>0 and nb_sortie_moins_bonne_saison<=7
        group by  A.region_niv1
	order by TOTAL desc
	)

	  select distinct ABSCISSE,'NB sorties meilleure saison' as GROUPE,
	  TOTAL from meilleures_nb_sorties union select distinct ABSCISSE,'NB sorties mauvaise saison' as GROUPE, TOTAL
	from moinsbonne_nb_sorties order by ABSCISSE,GROUPE