I have a table where cityName is a column.

I want to find if there are same cityName exists and if so how many count for each entry.

What is the query ?