关于球队胜负的问题,SQL如下: select Name as 球队, sum( case Score when '胜' then 1 else 0 end ) as 胜, sum( case Score when '负' then 1 else 0 end ) as 负 from T_Scores Group by Name