sql 求相同字段的某字段的和

Question

如何从上图表中把所有Name相同项全部的Count相加 并排序得到 下图

Answer 1

select name,sum(count) as count ;
from <表名> ;
group by name;
order by count desc

Answer 2

select name,sum(count) as count
from tabxxx
group by name
order by name