USE AdventureWorks
GO

SELECT  City, StateProvinceID, CustomerCount = count(*)
FROM Person.Address
GROUP BY City, StateProvinceID
HAVING count(*) > 1
ORDER BY count(*) DESC
GO