Longest Jumps

The longest jumps recorded in rated competition rounds, ordered by distance regardless of their style scores.

Rules

• Only jumps from rated competition rounds are included.
• Style scores are ignored, so the list may contain jumps that are not officially recognized as records because of a fall or hand contact on landing.

Code

select
	to_char(c.competition_started, 'Mon MM YYYY') as date,
	c.hill_city || ' HS' || c.hill_size as hill,
	j.jumper_name as jumper,
	distance
from results
join jumpers j using (jumper_id)
join competitions c using (race_id)
order by distance desc

Results