求SQL语句,既有count,又有sum该怎么做?ID Name ShuLiang 1 张三 32 李四 53 张三 1查询结果:Name ShuLiang CiShu张三 4 2李四 5 1 [解决办法]select name,sum(shuliang)as shuliang,count(*) as cishufrom tb group by name