Themes | |
Name of the indicator | |
Definition | |
Objectives | |
View | |
Calculation description | |
Reading guide | |
Data sources | |
Comments | |
Query |
with tmp1 as
(
select distinct rectangle as LIEU,sum(landings) as VAL from
landing_rect_sd inner join def_stocks_area using (species,rectangle)
where fishstock like 'nep.fu.16' and year_d>=2004
and annexe not like 'MED'
group by LIEU order by LIEU desc
)
,total as
(select sum(VAL) as tot from tmp1)
select distinct LIEU,100*VAL/tot as VAL from tmp1,total
|
Retour à la fiche |