case when

一张表数据如下
1900-1-1 胜
1900-1-1 胜
1900-1-1 负
1900-1-2 胜
1900-1-2 胜
写出一条SQL语句，使检索结果如下:
          胜  负
1900-1-1 2   1
1900-1-2 2   0

 

select distinct Date,
sum(case when Result='Win' then 1 else 0 end) as Win,
sum(case Result when 'Lose'then 1 else 0 end) as Lose
from test
group by Date

2中case when end的写法