3 比赛结果result表内容如下： Date Win 2017-07-12 胜 2017-07-12 负 2017-07-15 胜 2017-07-15 负 如果要生成下列结果, 正确的sql语句是：（）。 比赛日期 胜 负 2017-07-12 1 1 2017-07-15 1 1
选项：

A:select Date As 比赛日期, (case when Win='胜' then 1 else 0 end) 胜, (case when Win='负' then 1 else 0 end) 负 from result group by Date
B:select Date As 比赛日期, SUM(case when Win='胜' then 1 else 0 end) 胜, SUM(case when Win='负' then 1 else 0 end) 负 from result
C:select Date As 比赛日期, SUM( when Win='胜' then 1 else 0 end) 胜, SUM( when Win='负' then 1 else 0 end) 负 from result group by Date
D:select Date As 比赛日期, SUM(case when Win='胜' then 1 else 0 end) 胜, SUM(case when Win='负' then 1 else 0 end) 负 from result group by Date [object Object]
F:1