Write a select query that will be displayed the duplicated site name and how many times it is duplicated? | PHP Questions

SELECT sitename, COUNT(*) AS NumOccurrences
FROM tbl_sites
GROUP BY sitename HAVING COUNT(*) > 1