求高手帮忙写一条select语句
有一张表（offertable)数据如下：
offertime offerpact offercom baletype stoID balenumber baleprice offersum remark
2007-10-10 00:00:00AK3580华发mp3-5sk550 5023.501175.00无
2007-10-10 00:00:00AK3581华发mp3-6sk551 3525.50892.50无
2007-10-10 00:00:00AK3582华发mp4-1sk552 7045.003150.00无
2007-10-10 00:00:00AK3583盛开mp3-5sk553 5212.80665.60无
2007-10-10 00:00:00AK3584盛开mp3-6sk554 4575.503397.50无
2007-10-10 00:00:00AK3585盛开mp4-1sk555 7545.803435.00无
2007-10-10 00:00:00AK3586华发mp3-5sk556 2824.50686.00无
2007-10-10 00:00:00AK3587盛开mp4-1sk557 4557.602592.00无
2007-10-12 00:00:00AK3588宏阔mp4-4sk558 5657.803236.80无
2007-10-12 10:08:00AK3589宏阔mp4-5sk559 5657.803236.80无
现在要求得到下面结果(对产品按不同厂家，不同规格分别总汇)
offercom baletype balenumber offersum
华发 mp3-5 78 1861.00
华发 mp3-6 35 892.50
华发 mp4-1 70 3150.00
盛开 mp3_5 52 665.60
盛开 mp3-6 45 3397.50
盛开 mp4-1 120 6027.00
宏阔 mp4-4 56 3236.80
宏阔 mp4-5 56 3236.80
请各位高手为我指点指点小弟在线等了
[解决办法]
select offercom,baletype,sum(balenumber) balenumber, sum(balenumber*baleprice) offersum
from tb
group by offercom,baletype
[解决办法]
select offercom,baletype,balenumber=sum(balenumber),
offersum=sum(offersum)
from offertable group by offercom,baletype
我对新版真的无语了...........................................
等半天回答框才出来
