SQL 同一行显示分组

数据库的表结构是这样的

 

然后需要得到这样的查询结果

 

sql语句是这样的

 

select name,

'b1' as b1,   sum(case when bag = 'b1' then money end),

'b2' as b2,   sum(case when bag = 'b2' then money end),

'sum' as summ,sum(money)

from testtable

group by name;