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.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #319: Sports Spots

ARussell34
8 - Asteroid

I have 47 cities that don't have all 5 "big leagues", 10 cities that do.

TKoep
6 - Meteoroid

solution

 

I believe there should be 48 cities - New York doesn't have a MLS or NFL team.

TKoep_0-1663954383663.png

 

SylwiaDragon
8 - Asteroid

done

peterr_h
6 - Meteoroid

Think that New York City may be missing from the Output, as there's no NFL team there yet it's not included?

martinding
8 - Asteroid

A very good use case for the "Find and Replace" Tool!

Spoiler
319.png

nandagaikwad03
8 - Asteroid
Spoiler
Challenge_319_Workflow.png

 Loved the Sports theme :)

peterr_h
6 - Meteoroid

I got 47 too - my reasoning was that it has 2 Ice Hockey teams, so the given solution (sorting by team names) doesn't find distinct leagues. However, I'm in agreement with your answer!

Supergiant
8 - Asteroid
Spoiler
Supergiant_0-1665668903087.png
Turley93
7 - Meteor

Solution

jflanigan
8 - Asteroid

Similar to others, I used a countdistinct on Leagues and came up with 48 (vs solution of 47) teams.  NYC is the difference with 5 teams but not 5 leagues.

Spoiler
jflanigan_0-1666207751372.png