mysql 从表中选出数据然后排序

select Country,num from (SELECT count(*) as num,Country FROM `webdata80` group by Country ) a order by num desc

其中a为派生表的别名