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're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackI had the same issues with the solution, Tony, so I ignored the solution. This may be another one they need to amend after publishing it.
Great Challenge! I opted to use a Regex_Match, Unique, and Join in order to appoint those cities' missing states as mentioned.
Quick and easy one in 6 steps.
There's a little trick to this one. New York City is not in the answer but should be giving 48 Cities. NYC has 5 teams but does not span the 5 leagues (NBA x 2, NHL x 2, MLB).
I also have 48 records as output.
" do not have a team from all 5 leagues." maybe should be interpretted as at least one team from the five leagues.