World Cup Winners Compared

A comparison of World Cup winners across seasons that accounts for differences in the number of competitions held.

Rules

• Only the winner of each season’s World Cup standings is included.
• Each winner’s total points and number of competition performances are shown.
• Average points per performance are calculated by dividing total points by the number of performances.

The analysis uses the world_cups view created for the season standings. Comparing average points per performance makes the result fairer when seasons contain different numbers of competitions.

Code

with comparison as (
	select 
		wc.season,
		j.jumper_name as jumper,
		wc.total_score as points,
		(
			select count(cr.*)
			from competition_results cr
			join competitions c using (race_id)
			where c.season = wc.season and cr.jumper_id = j.jumper_id
		) as number_of_performances
	from world_cups wc
	join jumpers j using (jumper_id)
	where pos = 1
	order by season
)
select *,
	(points / number_of_performances)::decimal(10,2) as avg_points_per_performance
from comparison;

Results

season	jumper	points	number_of_performances	avg_points_per_performance
2017/2018	STOCH Kamil	1443	22	65.00
2018/2019	KOBAYASHI Ryoyu	2085	28	74.00
2019/2020	KRAFT Stefan	1659	27	61.00
2020/2021	GRANERUD Halvor Egner	1572	25	62.00
2021/2022	KOBAYASHI Ryoyu	1621	25	64.00
2022/2023	GRANERUD Halvor Egner	2128	31	68.00
2023/2024	KRAFT Stefan	2149	32	67.00
2024/2025	TSCHOFENIG Daniel	1805	29	62.00
2025/2026	PREVC Domen	2148	28	76.00