Back to feed

Project docs

Ski Jumping Statistics

PostgreSQL analysis of men's Ski Jumping World Cup results, supported by a Python data collection pipeline.

Jumpers by Country

A country-by-country count of jumpers represented in the dataset, based on competitions recorded since the 2017/18 season.

Rules

  • Each jumper is counted once for the country assigned to them in the dataset.
  • The dataset covers competitions recorded from the 2017/18 season onward.

Code

select
	jumper_country as country,
	count(*) as number_of_jumpers
from jumpers
group by jumper_country
order by number_of_jumpers desc

Results

Jumpers by country returned by PostgreSQL0 rows