select Country,num from (SELECT count(*) as num,Country FROM `webdata80` group by Country ) a order by num desc
其中a为派生表的别名
select Country,num from (SELECT count(*) as num,Country FROM `webdata80` group by Country ) a order by num desc
其中a为派生表的别名