select distinct pays as ABSCISSE,''  as GROUPE,sum(proprietaire_pirogue*txa) as total from
total.liste_site inner join total.calcul_txa using (strate,pays)
inner join total.v_liste_menage using (no_site,pays) where proprietaire_pirogue<10
group by pays order by total desc