Icon

JKISeason3-11_​RBre

Olympic Trivia

Challenge 11
Level: Easy

Description: 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?

If you're not sure about the answers, don't sweat it: we've got a handy dataset that covers the entire history of the Games for you. Before you know it, you'll be standing on the virtual podium as the trivia champion, ready to take home the gold!

Author: Michele Bassanelli

URL: 1 https://api.hub.knime.com/repository/Users/alinebessa/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2011%20-%20Datasets/athlete_events.csv:data?version=current-state
URL: 2 https://api.hub.knime.com/repository/Users/alinebessa/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2011%20-%20Datasets/noc_regions.csv:data?version=current-state

1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across allSummer Olympics? 2. Which sport made its debut at the Rio 2016 Olympics?first try 3. Who holds the title of the oldest gold medalist of all time? 2. Which sport made its debut at the Rio 2016 Olympics?second try athlete_events.csvnoc_regions.csvSummerWinterMedal NAMedal BronzeMedal SilverMedal GoldNOCMedals per AthleteNode 2037SIN to SGPRegionNode 2041Sport20162012200820042000197219761980198419881992199619681964192019601956195219481936193219281924191218961900190419061908SportNode 2095SummerWinter2006193220101936194820141952195619601964200219241928199419921988198419801976197219981968SportNode 2148Node 2149Node 2151Node 2152Node 2153Node 2154Node 2155Node 2156Node 2157Node 2158Node 2159Node 2160Node 2161 CSV Reader CSV Reader Row Splitter String Manipulation String Manipulation String Manipulation String Manipulation Row Aggregator Math Formula Value Lookup String Manipulation Row Aggregator DuplicateRow Filter Column Filter Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Row Aggregator Heatmap(JavaScript) Row Splitter Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Row Aggregator Heatmap(JavaScript) Row Filter Rank Column Resorter Column Resorter Rank Row Filter Rank Column Resorter Math Formula String to Number DuplicateRow Filter Sorter 1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across allSummer Olympics? 2. Which sport made its debut at the Rio 2016 Olympics?first try 3. Who holds the title of the oldest gold medalist of all time? 2. Which sport made its debut at the Rio 2016 Olympics?second try athlete_events.csvnoc_regions.csvSummerWinterMedal NAMedal BronzeMedal SilverMedal GoldNOCMedals per AthleteNode 2037SIN to SGPRegionNode 2041Sport20162012200820042000197219761980198419881992199619681964192019601956195219481936193219281924191218961900190419061908SportNode 2095SummerWinter2006193220101936194820141952195619601964200219241928199419921988198419801976197219981968SportNode 2148Node 2149Node 2151Node 2152Node 2153Node 2154Node 2155Node 2156Node 2157Node 2158Node 2159Node 2160Node 2161CSV Reader CSV Reader Row Splitter String Manipulation String Manipulation String Manipulation String Manipulation Row Aggregator Math Formula Value Lookup String Manipulation Row Aggregator DuplicateRow Filter Column Filter Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Row Aggregator Heatmap(JavaScript) Row Splitter Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Math Formula Row Aggregator Heatmap(JavaScript) Row Filter Rank Column Resorter Column Resorter Rank Row Filter Rank Column Resorter Math Formula String to Number DuplicateRow Filter Sorter

Nodes

Extensions

Links