Most Popular Cities
But that doesnt cut it. You're correct, your answer is a straight forward solution....but it doesn't solve the problem. The result set is the city name with the most zipcodes, but that doesn't mean it is the city name used most often in the US!
To find the answer, you must first eliminate all the duplicate city, state combinations. If there are 150 zipcodes for cities called "Houston", you need to make sure narrow it down until you only have a subset that includes "Houston, MO" and "Houston, TX".
Once that is done, then you can run your query to count the city names.
Does that constitute stumped?
Kobiashi Maru - an unwinnable situation?