mysql中记录某一字段中重复的个数并且按照次数排序

select Author, count(*) AS count from spiderdb.author group by Author order by count DESC;