结果:
select name as 队名,
sum(case Score when N'胜' then 1 else 0 end)as 胜,
sum(case Score when N'平' then 1 else 0 end)as 平,
sum(case Score when N'负' then 1 else 0 end)as 负,
--自定义列 计算积分(胜+3 平+1 负+0)
sum(case Score when N'胜' then 3 when N'平' then 1 end) as 积分
from T_Scores group by name
order by 积分 desc