1 2 3 4 5 6 7 8 9 10 11
| select alg_num_contr, alg_dt_trait_evt_gen, alg_dt_effet , alg_dt_valorisation_prest, alg_cd_evt_gen, alg_cd_sup,
sum(alg_mnt_synth_pure),
sum(alg_val_liquidative_uc),
sum(alg_nb_unite_compte),
sum(alg_mnt_dr_entr),
sum(alg_val_liquidative_uc) * sum(eva_nb_unite_compte) e,
sum(alg_mnt_synth_pure)+sum(eva_mnt_dr_entr) f
from tbl_alg_evt
where ((alg_mnt_synth_pure)+(alg_mnt_dr_entr)) != 0
and (select sum(((alg_val_liquidative_uc) * (alg_nb_unite_compte))/((alg_mnt_synth_pure)+(alg_mnt_dr_entr))) from tbl_alg_evt group by alg_num_contr) > 2
group by alg_num_contr, alg_dt_trait_evt_gen, alg_dt_effet, alg_dt_valorisation_prest, alg_cd_evt_gen, alg_cd_sup |
Partager