Table2

 
select name,
sum(
 case score
 when N'胜' then 1
    else 0
 end
) as '胜',
sum(
 case score
    when N'败' then 1
    else 0
    end
) as '败' from table2 group by name

 

原始数据最终效果