SqlServer分组求和

--根据字段分组求和
 select 
类型字段=t.类型字段,
sum(t.字段1) '字段1', 
sum(t.字段2) '字段2', 
sum(t.字段3) '字段3', 
sum(t.字段4) '字段4', 
sum(t.字段5) '字段5', 
convert(varchar,Convert(decimal(18,2),(sum(t.字段3)+sum(t.字段4))/sum(t.字段2)*100))+'%'  'xx拉新率',
convert(varchar,Convert(decimal(18,2),sum(t.字段5)/NULLIF(sum(t.字段1),0)*100))+'%' 'xx终端拉新率'
 from tab1   as t group by t.类型字段