急啊，SQL要得到这样的结果？

Question

SELECT mode1,SUM(DECODE(breadth,'10',pcs,NULL)) breadth10,
     SUM(DECODE(breadth,'20',pcs,NULL)) breadth20,
     SUM(DECODE(breadth,'30',pcs,NULL)) breadth30
FROM test 
GROUP BY mode1;MODE1    BREADTH10  BREADTH20  BREADTH30
----- ----------   ----------  ----------
A              5         10          3
B              2                     6
C                         8

Answer 1

怎么没人帮我顶呀，好急啊！