Requête |
with T1 as (
(select distinct pays as ABSCISSE,'nb femmes pêche' as GROUPE,sum(nb_femme_peche*txa) as TOTAL
from
total.liste_site inner join total.calcul_txa using(pays,strate)
inner join total.v_liste_menage using (pays,no_site)
group by ABSCISSE order by ABSCISSE )
union
(select distinct pays as ABSCISSE,'nb femmes transfo' as GROUPE,sum(nb_femme_transfo*txa) as TOTAL
from
total.liste_site inner join total.calcul_txa using(pays,strate)
inner join total.v_liste_menage using (pays,no_site)
group by ABSCISSE order by ABSCISSE )
union
(select distinct pays as ABSCISSE,'nb femmes commerce' as GROUPE,sum(nb_femme_commer*txa) as TOTAL
from
total.liste_site inner join total.calcul_txa using(pays,strate)
inner join total.v_liste_menage using (pays,no_site)
group by ABSCISSE order by ABSCISSE ))
select * from T1 where total>0 order by abSCISSE,GROUPE
|