Most popular concert city from votes, with name variants and weights
Given vote records naming venue cities for a concert, return the most popular city. Follow-ups: the same city appears under many spellings (NYC, New York, new york city), so how do you normalize or cluster names into one entity; and some votes carry weights, so how does the count change. Talk through the approach as you code it.
No answer yet. Write the first one; the best answer gets endorsed.
