Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #319: Sports Spots

ARussell34
8 - Asteroid

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

TKoep
7 - Meteor

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
8 - Asteroid

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

martinding
13 - Pulsar

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
8 - Asteroid

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
8 - Asteroid

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