mysql group by和order by

select column,count(*) a from table group by column order by a;

对table表的column列，进行分组统计并排序。