| 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 'bss.27.4bc7ad–h' 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 | |
