A solution to last week’s challenge can be found here.
The Eurovision Song contest or Eurovision is an annual song competition in Europe.
During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".
The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.
Use the dataset to:
- Find out which country has won the contest from 1975 to 2019
- List by descending order the countries who have won the most time between these dates
A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets.