求如下的果，SQL怎？
我目前有的一表,表的位名有
ColorNo XXS XS S M L XL XXL 箱 之和
001 10 5 10 2 25
001 5 1 5
021 25 4 25
021 5 1 5


我在要做一合是下面的
ColorNo XXS XS S M L XL XXL
001 25 10 20
021 105



[解决办法]
create table t(ColorNo varchar(10),XXS int,XS int,S int,M int,L int,XL int,XXL int,
箱 int,之和 int)
insert t select '001 ', ' ',10,5,10, ' ', ' ', ' ',2,25
union all select '001 ', ' ',5, ' ', ' ', ' ', ' ', ' ',1,5
union all select '021 ',25, ' ', ' ', ' ', ' ', ' ', ' ',4,25
union all select '021 ',5, ' ', ' ', ' ', ' ', ' ', ' ',1,5

select ColorNo,XXS=sum(箱*XXS),XS=sum(箱*XS),S=sum(箱*S),M=sum(箱*M),L=sum(箱*L),
XL=sum(箱*XL),XXL=sum(箱*XXL) from t group by ColorNo


ColorNo XXS XS S M L XL XXL
---------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
001 0 25 10 20 0 0 0
021 105 0 0 0 0 0 0

（所影响的行数为 2 行）