問題描述

問題解答

試試下面的語句：

select team_name,sum(if(score=’正’,1,0)) as’正’,sum(if(score=’負(fù)’,1,0)) as ’負(fù)’ from teamscore group by team_name;回答2：

應(yīng)該是：

SELECT team_name, count(*) AS win WHERE score = ’正’ GROUP BY team_nameSELECT team_name, count(*) AS loss WHERE score = ’負(fù)’ GROUP BY team_name

再想辦法把這兩個結(jié)果合起來。