Requête |
with valeur_nombre as
(select distinct pays as ABSCISSE,
replace(replace(type_engin,'Filet dérivant ',''),'Filet dormant ','') as GROUPE,sum(nombre*txa*txb*txc) as VAL
from
total.liste_site
inner join total.calcul_txa using (pays,strate)
inner join total.calcul_txc using (pays,strate)
inner join total.calcul_txb using(pays,no_site)
inner join total.v_liste_menage using (pays,no_site)
inner join total.v_menage_poss_engin using(pays,no_menage)
where type_engin like 'Filet do%' and date_enquete_m is not null
group by pays,GROUPE order by VAL desc
)
select distinct ABSCISSE,GROUPE,round((val/somtot*100)::numeric,2) as TOTAL
from valeur_nombre inner join (select distinct ABSCISSE,sum(val) as somtot from valeur_nombre group by ABSCISSE) tot
using (ABSCISSE)
order by ABSCISSE
|