with part1 as
(select distinct A.region_niv1 as ABSCISSE,strate,lib_statut_site as GROUPE,count(no_site)*txa as TOTAL
from ci.pre_enquete_village A  inner join ci.liste_site  B using(no_enquete) inner join ci.calcul_txa using(strate)
where B.date_enquete is not null group by lib_statut_site,A.region_niv1,txa,strate
)
select distinct ABSCISSE,GROUPE,sum(total) as TOTAL from part1 group by ABSCISSE,GROUPE
order by ABSCISSE