Icon

JKISeason3-11_​tark

Olympic Trivia

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

Dataset: Olympics Data on KNIME Community Hub


URL: JKISeason3-11 https://www.knime.com/just-knime-it?pk_vid=f1a9625dd14a14c5171698895027e10b
URL: Dataset https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2011%20-%20Datasets~0ZU77bFfP3HpQ2l3/
URL: this challenge thread https://forum.knime.com/t/solutions-to-just-knime-it-challenge-11-season-3/81309

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 yourknowledge: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 youknow it, you'll be standing on the virtual podium as the trivia champion, ready to take home the gold!Author: Michele BassanelliDataset: Olympics Data on KNIME Community Hub Q1 Q3 Q2 athlete_events.csvnoc_regions.csvNode 56Group by NOCcount "medal" unique count "name"NA > missingMedals per athleteFilter by summerAmend NOC(SGP > SIN)Sort by Agein Descending orderFilter by goldRank by AgeFilter by Rank = 1GamesUpdate valueYear, SportGroup by SportsType based aggregation(Maximum Integer)Sort colums by yearNode 900: summer1: winterSort by Agein Descending orderAgeRank by AgeFilter by Rank = 1Mark the year wheneach sport was first heldCSV Reader CSV Reader Value Lookup GroupBy String Manipulation Math Formula Row Splitter String Replacer Sorter Row Splitter Rank Row Splitter One to Many Domain Calculator DuplicateRow Filter GroupBy Column Resorter Top k Row Filter Row Splitter Sorter String to Number Rank Row Splitter Metanode Component 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 yourknowledge: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 youknow it, you'll be standing on the virtual podium as the trivia champion, ready to take home the gold!Author: Michele BassanelliDataset: Olympics Data on KNIME Community Hub Q1 Q3 Q2 athlete_events.csvnoc_regions.csvNode 56Group by NOCcount "medal" unique count "name"NA > missingMedals per athleteFilter by summerAmend NOC(SGP > SIN)Sort by Agein Descending orderFilter by goldRank by AgeFilter by Rank = 1GamesUpdate valueYear, SportGroup by SportsType based aggregation(Maximum Integer)Sort colums by yearNode 900: summer1: winterSort by Agein Descending orderAgeRank by AgeFilter by Rank = 1Mark the year wheneach sport was first heldCSV Reader CSV Reader Value Lookup GroupBy String Manipulation Math Formula Row Splitter String Replacer Sorter Row Splitter Rank Row Splitter One to Many Domain Calculator DuplicateRow Filter GroupBy Column Resorter Top k Row Filter Row Splitter Sorter String to Number Rank Row Splitter Metanode Component

Nodes

Extensions

Links