一个数据库面试题，求更好解法

数据准备（mysql）：

/*DDL 信息*/------------

CREATE TABLE `a` (
  `date` VARCHAR(12) DEFAULT NULL,
  `result` CHAR(4) DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8
/*数据准备*/
INSERT INTO A(DATE,result) VALUE('2005-05-09','胜');
INSERT INTO A(DATE,result) VALUE('2005-05-09','胜');
INSERT INTO A(DATE,result) VALUE('2005-05-09','负');
INSERT INTO A(DATE,result) VALUE('2005-05-09','负');
INSERT INTO A(DATE,result) VALUE('2005-05-10','胜');
INSERT INTO A(DATE,result) VALUE('2005-05-10','负');
INSERT INTO A(DATE,result) VALUE('2005-05-10','负');

我的sql实现，用了个子查询：

SELECT t.date, SUM(t.V) AS '胜', SUM(t.F) AS '负'
 FROM(
    SELECT 
    a.`date`,
    IF(a.`result`='胜',COUNT(a.`date`),0) AS 'V',
    IF(a.`result`='负',COUNT(a.`date`),0) AS 'F'
  FROM
    A 
  GROUP BY a.`date`,
    a.`result`
    ) AS t
    GROUP BY t.date

实现效果：
子查询：

》》》求更好写法？？？