关于sql group by的问题

Question

create table A
(
sid VARCHAR2(50),
sname VARCHAR2(50),
scount NUMBER,
stime DATE
)

insert into A (sid, sname, scount, stime)
values ('1', '品种1', 10, to_date('01-01-2015', 'dd-mm-yyyy'));
insert into A (sid, sname, scount, stime)
values ('2', '品种2', 20, to_date('01-01-2015', 'dd-mm-yyyy'));
insert into A (sid, sname, scount, stime)
values ('2', '品种2', 20, to_date('02-01-2015', 'dd-mm-yyyy'));
insert into A (sid, sname, scount, stime)
values ('3', '品种3', 30, to_date('01-01-2015', 'dd-mm-yyyy'));
insert into A (sid, sname, scount, stime)
values ('3', '品种3', 30, to_date('02-01-2015', 'dd-mm-yyyy'));
insert into A (sid, sname, scount, stime)
values ('3', '品种3', 30, to_date('03-02-2015', 'dd-mm-yyyy'));

想通过查询获得以下格式,求大神帮忙
SID SNAME 1月1日数量 1月数量 总数量
1 品种1 10 10 10
2 品种2 20 40 40
3 品种3 30 60 90

Answer 1

这不就是sql 行转列么。。参考：

http://www.cnblogs.com/IcefishBingqing/archive/2010/12/22/1913349.html
http://www.cnblogs.com/maanshancss/archive/2013/03/13/2957108.html