select 类型, ltrim(cast(count(1)*100.0/(select count(1) from tb) as dec(18,2)))+'%' from tb group by 类型