Largest Winning Margins

The World Cup victories with the greatest points difference between the winner and the runner-up.

Rules

• The winner and runner-up are selected from each competition’s final results.
• The winning margin is the winner’s total points minus the runner-up’s total points.
• Competitions are ranked from the largest winning margin downward.

The calculation uses final positions and total points from the competition_results materialized view.

Calculating each margin

create view advantages_over_second_player
as
with top_results as (
	select *,
		row_number() over (partition by race_id order by total_points desc) as rn
	from competition_results
	where pos < 3
)
select
	c.race_id,
	first_place.jumper_id as first_place_jumper_id,
	second_place.jumper_id as second_place_jumper_id,
	(first_place.total_points - second_place.total_points)::decimal(10, 2) as advantage
from competitions c
join top_results as first_place on
	first_place.race_id = c.race_id and first_place.rn = 1
join top_results as second_place on
	second_place.race_id = c.race_id and second_place.rn = 2;

Raw view presentation

race_id	first_place_jumper_id	second_place_jumper_id	advantage
4916	122	81	2.80
4918	67	68	0.60
4919	72	67	4.80
4922	67	72	2.40
4924	88	67	0.10
4925	67	65	11.60
4927	65	67	4.20
4929	65	67	7.60
4931	65	68	14.50
4933	65	88	3.20
4935	77	68	2.50
4945	111	72	3.60
4947	68	67	0.80
4948	81	65	2.00
4952	65	73	27.70
4954	65	66	17.00
4957	76	77	5.40
4959	65	81	3.70
4961	65	66	15.50
5001	64	65	2.30

Top 10 winning margins

select
	j1.jumper_name as first_place,
	j2.jumper_name as second_place,
	aosp.advantage as winning_margin,
	to_char(c.competition_started, 'Mon DD YYYY') as date,
	c.hill_city || ' HS' || c.hill_size as hill
from advantages_over_second_player aosp
join competitions c using (race_id)
join jumpers j1 on aosp.first_place_jumper_id = j1.jumper_id
join jumpers j2 on aosp.second_place_jumper_id = j2.jumper_id
order by aosp.advantage desc
limit 10;

Results

first_place	second_place	winning_margin	date	hill
HUBER Daniel	PREVC Domen	43.40	Mar 24 2024	Planica HS240
PREVC Domen	NIKAIDO Ren	31.70	Feb 01 2026	Willingen HS147
FORFANG Johann Andre	KOBAYASHI Ryoyu	31.00	Feb 03 2024	Willingen HS147
STOCH Kamil	EISENBICHLER Markus	28.20	Mar 04 2018	Lahti HS130
STOCH Kamil	KUBACKI Dawid	27.70	Mar 13 2018	Lillehammer HS140
KOBAYASHI Ryoyu	KUBACKI Dawid	26.50	Jan 12 2019	Val di Fiemme HS135
KUBACKI Dawid	LANISEK Anze	25.70	Dec 11 2022	Titisee Neustadt HS142
PREVC Domen	KRAFT Stefan	25.50	Dec 13 2025	Klingenthal HS140
PREVC Domen	EMBACHER Stephan	24.80	Mar 01 2026	Kulm HS235
KRAFT Stefan	PEIER Killian	23.00	Dec 08 2019	Nizhny Tagil HS134