sql根据条件展示结果
sql语句要展示这样的结果，目前没有思路，展示一个胜负的的次数
SELECT DATECAERDTIME, SUM(IF(RESULT='胜', 1, 0)) as 'Victory', SUM(IF(RESULT='负', 1, 0)) as 'Failed' FROM MatchResult GROUP BY DATECAERDTIME
使用分组就会只展示日期，还有用count统计次数顺便给个别名判断==胜和==负的次数
SELECT DATECAERDTIME, SUM(IF(RESULT='胜', 1, 0)) as 'Victory', SUM(IF(RESULT='负', 1, 0)) as 'Failed' FROM MatchResult GROUP BY DATECAERDTIME
使用分组就会只展示日期，还有用count统计次数顺便给个别名判断==胜和==负的次数