A solution to last week’s challenge can be found here.
Many countries host competition where people compete for the fastest Rubik's cube solve times. Using the following three datasets on competitions and competitor solve times, complete the following tasks:
1. Find the ten countries that have hosted the most competitions and how many each one has hosted
2. Find the difference in average solve times between competitors who are in their home country vs. visiting and create a table with the results
3. Find the difference in fastest solve times between competitors who are in their home country vs. visiting and create a table with the results
4. Append to the task 1 results the competitor's name and time for both the minimum fast time and the fastest minimum average time and create a table with the results
Bonus: Combine all tables with the top 10 country results at the top.