关于数据库查询并进行统计的问题，请教各位!

Question

select class,Qnty=count(Name) from 表
group by class

Answer 1

select class,count(name) as counts from 表 group by class order by counts

Answer 2

select class,count(name)as nub from yourtable group by class order by count(name)

Answer 3

select class,count(name)as nub from yourtable group by class