Icon

JKISeason3-11 - 2024 Challenge 11 - Olimpic Trivia

Olympic TriviaChallenge 11Level: EasyDescription: The 2024 Summer Olympics start this week: are you ready for some on-theme trivia? Here are three questions to test your knowledge:1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across all Summer Olympics?2. Which sport made its debut at the Rio 2016 Olympics?3. Who holds the title of the oldest gold medalist of all time? athlete_events.csvnoc_regions.csvJoin NOC (Name of Country)Filter SummerOlympicsCalculateNumber ofMedalsFilter ColumnsRegion, Athlete andnumber MedalsSort ColumnsRegion, Athlete andnumber MedalsAdd Medals per Region andunique Athletes forevery RegionCalculate Average between Number Medals and Athletes for every RegionSort descendingRegionsaccording Average between Number Medals and Athletes for every RegionFilter Region withMax Averagebetween Number Medalsand AthletesFilter Sports andOlympic GamesSort Sport &Olympic GamesSort ColumnsCalculateFirst Olympic ofevery SportFilter Sportwhose firstOlympic was2016 RioFilter Medals ofAthletes withage knownSortper Age ofAthleteFilter older medalistShow RegionFilter RegionFilter SportShow SportShow AthleteFilter Athlete CSV Reader CSV Reader Joiner Row Filter Rule Engine Column Filter Column Resorter GroupBy Math Formula Sorter Row Sampling GroupBy Sorter Column Resorter GroupBy Row Filter Row Filter Sorter Row Sampling Data toReport (BIRT) Column Filter Column Filter Data toReport (BIRT) Data toReport (BIRT) Column Filter Olympic TriviaChallenge 11Level: EasyDescription: The 2024 Summer Olympics start this week: are you ready for some on-theme trivia? Here are three questions to test your knowledge:1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across all Summer Olympics?2. Which sport made its debut at the Rio 2016 Olympics?3. Who holds the title of the oldest gold medalist of all time? athlete_events.csvnoc_regions.csvJoin NOC (Name of Country)Filter SummerOlympicsCalculateNumber ofMedalsFilter ColumnsRegion, Athlete andnumber MedalsSort ColumnsRegion, Athlete andnumber MedalsAdd Medals per Region andunique Athletes forevery RegionCalculate Average between Number Medals and Athletes for every RegionSort descendingRegionsaccording Average between Number Medals and Athletes for every RegionFilter Region withMax Averagebetween Number Medalsand AthletesFilter Sports andOlympic GamesSort Sport &Olympic GamesSort ColumnsCalculateFirst Olympic ofevery SportFilter Sportwhose firstOlympic was2016 RioFilter Medals ofAthletes withage knownSortper Age ofAthleteFilter older medalistShow RegionFilter RegionFilter SportShow SportShow AthleteFilter Athlete CSV Reader CSV Reader Joiner Row Filter Rule Engine Column Filter Column Resorter GroupBy Math Formula Sorter Row Sampling GroupBy Sorter Column Resorter GroupBy Row Filter Row Filter Sorter Row Sampling Data toReport (BIRT) Column Filter Column Filter Data toReport (BIRT) Data toReport (BIRT) Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: fmc00006
Created at: 2024-07-24
On NodePit since: 2024-07-26
Last update: 2024-11-21
Created with KNIME version: v5.3.0
Tags: JKISeason3-11

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!