select 号码,Count() from 表明 group by 号码 ORDER BY Count() DESC