select column,count(*) a from table group by column order by a;
对table表的column列，进行分组统计并排序。
mysql group by和order by
原文：https://www.cnblogs.com/zhh2020/p/13998417.html
