Challenge #319: Sports Spots

[AYXAcademy]

A solution to last week’s challenge can be found here. 

Sports franchises are not only valuable, but they often become integral to the identity of the cities they represent. These “big league” teams usually inhabit only the largest cities to ensure there are plenty of fans nearby to buy tickets and jerseys! The NFL, NBA, MLB, MLS, and NHL have different demographics and they don’t always inhabit the same cities.

For this week’s challenge, use the 5 datasets provided to find the cities that do not have a team from all 5 leagues.

Your output should list the teams and their leagues for those cities. Note that some of the city information is missing a state, but you can grab those missing values from another dataset that has the same city!

[scoles0617]

My solution:

[AkimasaKajitani]

My solution.

スポイラ

[joelmiller66]

I think we need all the major sports on the list :)

Happy INSPIRE WEEK!!!!

スポイラ

[RolandSchubert]

スポイラ

[binuacs]

solution attached

[dYoast]

Interesting results.

スポイラ

[Reesetrain2]

All,

スポイラ

Pretty straight forward challenge, although I love the sports theme.
-1 Union
-1 Text to Column
-1 Data Cleansing
-1 Select
-1 Summation (I used a comma separator vice the new line for astetics)
-1 Filter
-1 Sort
Technically, the Bronx is a bureau of New York City, so really shouldn't be on the list..

 

[balajilolla1]

スポイラ

Solution Attached

[smitj160]

スポイラ

Spoiler