Contador de repetidos SQL

SELECT id, count(*) AS count_ , titulo, id_medio FROM noticias GROUP BY titulo HAVING count(*) > 1 ORDER BY count_ DESC