oracle 查询问题

Question

create table test(
       rq varchar2(10),
       shengfu varchar2(2)
);insert into test values ('2012-1-1','胜');
insert into test values ('2012-1-2','负');查询显示为：
           胜     负
2012-1-1   1       1
求解！

Answer 1

select rq,
       sum(decode(shengfu,'胜',1,0)) 胜,
       sum(decode(shengfu,'负',1,0)) 负
from test
group by rq

Answer 2

select rq,sum(decode(shengfu,'胜',1,0)) 胜,sum(decode(shengfu,'负',1,0)) 负 from test
group by rq