MySQL: Fetching distinct records from table HAVING COUNT greater than 3

[code language=”sql”]
SELECT city, COUNT(id) AS id
FROM YourTable
GROUP BY city
HAVING COUNT(id) > 3
[/code]