Given your GROUP BY clause, your DISTINCT keyword is completely unnecessary. And, by the way, the second column may be equivalently specified as COUNT(*) [AS] col2 or col2=COUNT(*).

The ORDER BY clause may alternatively be specified as ORDER BY 2 DESC or as ORDER BY count(*) DESC.