Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAQuite a mean one I think for a beginner, however a great one to work through, and cool to use one of the 'secondary' uses of a Join tool.
TheOC
my solution:
my results are a tad different because I have removed duplicates. i.e. one song that made the top 100 more than one year only counts once. The interesting outcome is that the artists order do not change when compared to the "Output"! Also interesting that the Beatles never had the same song make the top 100 more than one year, saying that one could still argue the songs of yesteryear were made to last!
Top 100:
Top 10:
Fun challenge, here is my solution: