有如下一个表bisai
racedate    result
2009-07-16    胜
2009-07-16    胜
2009-07-16    负
2009-07-17    胜
2009-07-17    负
2009-07-17    胜
2009-07-17    负
写个sql语句,要求输出结果为:
RACEDATE   胜   负
2009-07-16 2    1
2009-07-17 2    2谢谢,先睡个觉,明天起来结帖