MySql 中关键字 case when then else end 的用法

1.世界杯某次统计记录如下，请按照日期统计每日胜负

sf	date
负	2017-04-10 00:00:00.000000
胜	2017-04-10 00:00:00
负	2017-04-9 00:00:00
负	2017-04-9 00:00:00
胜	2017-04-9 00:00:00
胜	2017-04-18 00:00:00

sql语句：

SELECT
date,
sum(case when sf='胜' then 1 else 0 end) as '胜', #当统计到胜，输出1，并求和
sum(case when sf='负' then 1 else 0 end) as '负'
from shengfu GROUP BY date

运行结果：

date	胜	负
2017-04-09 00:00:00	1	2
2017-04-10 00:00:00	1	1
2017-04-18 00:00:00	1	0

当只需要查找胜或者负：

select date,count(*) as '胜' from shengfu WHERE sf='胜'  GROUP BY date 

具体用法参考：https://www.cnblogs.com/anche/p/9038802.html