Requête |
with cal_nb_mois as
(
select distinct pays,no_selection,sum(janvier::int+fevrier::int+mars::int+avril::int+mai::int+juin::int+juillet::int+aout::int+septembre::int+octobre::int+novembre::int+decembre::int) as nbmois from total.selection_mois_generique where no_selection in (11,12,13,14,15,16,17,18,19)
group by pays,no_selection
)
,tot_nb_mois as
(
select distinct pays,sum(nbmois) as nb_total from cal_nb_mois group by pays
)
select distinct pays as ABSCISSE,'Mois fumage' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays)
where no_selection=11
union
select distinct pays as ABSCISSE,'Mois sechage' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=12
union
select distinct pays as ABSCISSE,'Mois salage' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=13
union
select distinct pays as ABSCISSE,'Mois fermentations' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=14
union
select distinct pays as ABSCISSE,'Mois brulage' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=15
union
select distinct pays as ABSCISSE,'Mois braisage' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=16
union
select distinct pays as ABSCISSE,'Mois huile' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=17
union
select distinct pays as ABSCISSE,'Mois farine' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=18
union
select distinct pays as ABSCISSE,'Autres' as GROUPE,100*nbmois/nb_total as total from cal_nb_mois inner join tot_nb_mois using(pays) where no_selection=19
order by ABSCISSE
|