MySQL Count with a condition

Question

Let's say I have a table which contains cities and names. But in a city, the names are duplicate. How can I count the duplicate names which belong to every distinct city?

Answer 1

select count(name) from Table group by CITY having count(*) > 1