A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop.
This challenge comes to us from @Pawel_Paleczny Thank you for your contribution.
The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.
The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.
The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.
For this challenge:
1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage.
2. Find the three cities with the most World Cup matches.