一道SQL语句面试题，关于group by

1.一道SQL语句面试题，关于group by
表内容：
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 A.mytime, A_result '胜', B_result '负' from (select distinct(mytime),count(myresult) as A_result from mytable where myresult='胜') A,
(select distinct(mytime),count(myresult) as B_result from mytable  where myresult='负') B where A.mytime=B.mytime
-----分析---错， from  子A表,子B表中，需要查出关联的字段(如:mytime),且不要用distinct,用group by,
--------
select  distinct(mytime),sum(case when myresult='胜' then 1 else 0 end) '胜',
sum(case when myresult='负' then 1 else 0 end) '负' from mytable
-----分析----错--用了聚合函数sum，distinct无效

----------------------
select A.mytime, A_result '胜', B_result '负' from (select mytime,count(myresult) as A_result from mytable where myresult='胜' group by mytime) A,
(select mytime,count(myresult) as B_result from mytable  where myresult='负' group by mytime) B where A.mytime=B.mytime

select mytime,sum(case when myresult='胜' then 1 else 0 end) '胜',
sum(case when myresult='负' then 1 else 0 end) '负' from mytable group by mytime

select distinct(A.mytime),'胜'=(select count(*) from mytable where A.mytime=mytime and myresult='胜'),
'负'=(select count(*) from mytable where A.mytime=mytime and myresult='负') from mytable A

select A.mytime,'胜'=(select count(*) from mytable where A.mytime=mytime and myresult='胜'),
'负'=(select count(*) from mytable where A.mytime=mytime and myresult='负') from mytable A group by A.mytime
-----正确--------------