比赛结果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
select Date As 比赛日期,
(case when Win='胜' then 1 else 0 end) 胜,
(case when Win='负' then 1 else 0 end) 负 from result group by Date
select Date As 比赛日期,
SUM(case when Win='胜' then 1 else 0 end) 胜,
SUM(case when Win='负' then 1 else 0 end) 负 from result
select Date As 比赛日期,
SUM( when Win='胜' then 1 else 0 end) 胜,
SUM( when Win='负' then 1 else 0 end) 负 from result group by Date
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