-74급 남자 Total 상위 10명

# -74kg 남자 상위 10명 total
select a.name, r.total,r.squat,r.bench,r.deadlift,a.sex, r.body_weight, r.age,r.dots,r.wilks,r.glossbrenner,r.goodlift,r.tested,r.sanctioned,g.date,f.name as federation_name,pf.name as parent_federation_name
from athlete as a
left join (
    select r.athlete_id,r.game_id,r.body_weight,r.age,r.dots,r.wilks,r.glossbrenner,r.goodlift,r.tested,r.sanctioned,
           r.best_squat as squat,
           r.best_bench as bench,
           r.best_deadlift as deadlift,
           max(r.total) as total
    from athlete_game_record as r
    where r.body_weight > 66  and r.body_weight<=74
    and r.equipment = 'Raw'
    group by r.athlete_id
) as r on a.id = r.athlete_id
left join game as g on r.game_id = g.id
left join federation as f on g.federation_id = f.id
left join federation as pf on f.parent_federation_id = pf.id
where a.sex = 'M'
order by r.total desc
limit 10;

shininghyunho / pl_api

[DOCS] 통계정보 SQL #5

-74급 남자 Total 상위 10명

결과