This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
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.