求一个sql语句

[jlbqd]

我有一张表！里面有2个字段，是UserName和Book
UserName Book
A 数学
A 化学
B 数学


我现在想获取每个人的Book总数，不知道该怎么写！
UserName的人数有很多

[jlbqd]

问一下
怎么输入每个人book数量总和的结果啊！

[kencorn]

SELECT count(*),UserName from tablename group by UserName

[littlelam]

select UserName ,count(Book) from table group by UserName

[littlelam]

select UserName ,sum(Book) from table group by UserName

[caotian2000]

SELECT count(UserName),Book from tablename group by UserName