Citation :
select pron.joueich_login, joue_ch_nom, joue_ch_prenom, count(pron.joueich_login) as 'pron_in_nombre', sum(pron_in_points) as 'pron_in_points', sum(pron_in_bonus) as 'pron_in_bonus', sum(pron_in_points + pron_in_bonus) as 'pron_in_total', sum(pron_in_points + pron_in_bonus) / count(pron.joueich_login) as 'pron_fl_moy' from pron_competition_pronostic pron, pron_competition_match matc, comm_joueur joue where pron.grouiin_ci = 5 and matc.compiin_ci = 6 and pron.matciin_ci = matc.matciin_ci and pron.joueich_login = joue.joueich_login and matc.matc_ch_statut = 'T' group by pron.joueich_login order by pron_in_total desc
|