请按照要求写出sql语句
表内容:
2005-05-09 胜
2005-05-09 胜
2005-05-09 负
2005-05-09 负
2005-05-10 胜
2005-05-10 负
2005-05-10 负
如果要生成下列结果,怎样写sql?
胜 负
2005-05-09 2 2
2005-05-10 1 2
select [datetime],SUM(case when isw='胜' then 1 else 0 end) ,SUM(case when isw='负' then 1 else 0 end) from [w] group by [datetime]