扫码加入数据分析学习群

record表结构如下:

请用SQL实现以下结果

create table record(

time0 datetime,

shengfu varchar(10));

insert into record(time0,shengfu)

values('2015-01-12 00:00:00.000','胜'),

('2016-12-09 00:00:00.000','负'),

('2013-05-22 00:00:00.000','胜'),

('2015-01-12 00:00:00.000','胜'),

('2013-05-22 00:00:00.000','胜'),

('2016-01-12 00:00:00.000','负');

select * from record;

select time0,sum(shengfu='胜') 胜,sum(shengfu='负') 负 from record group by time0 order by time0;