select distinct pays as ABSCISSE,
type_pirogue as GROUPE,sum(nombre*txa*txc*txb) as total from
total.liste_site inner join total.calcul_txa using (strate,pays)
inner join total.calcul_txc using (strate,pays)
 inner join total.calcul_txb using(no_site,pays)
inner join total.v_liste_menage using (no_site,pays)
left join  total.v_menage_type_pirogue using(no_menage,pays)
where nombre<20 and date_enquete_m is not null
group by pays,type_pirogue order by ABSCISSE