The Most Popular Pub Names

Learn more about querying for the highest count and popular pub names.

Use case: Find the highest count of pubs

Let’s now find out which cities have the highest count of pubs, considering that a pub is affiliated with a city if it’s within five miles of the single point we have set as the city location in our dataset.

Get hands-on with 1200+ tech skills courses.