重複をカウントするSQL分

select FIELD count(FIELD) as cnt from TABLE
group by FIELD
order by cnt desc

mysql