表结构如下：
- date result
- 2019-11-12 win
- 2019-11-12 loss
- 2019-11-12 loss
- 2019-11-12 loss
- 2019-11-11 win
- 2019-11-11 win
- 2019-11-11 win
要求：
- date 胜 负
- 2019-11-12 1 3
- 2019-11-11 3 0
怎么写sql语句？
select date,sum(WIN) as '胜',sum(LOSS) as '负'
from (select date,
case result when win then 1 eles 0 end as WIN,
case result when loss then 1 else 0 end as LOSS from info) a
group by date
