求高手解答！该如何处理

求高手解答！！！！！！！！！！！！

 select 

    A.MO_NUMBER,

    (decode(A.GROUP_NAME , 'PACKING', count(*))) PACKING,

    (decode(A.GROUP_NAME, 'MAC INPUT', count(*))) MAC_INPUT,

    (decode(A.GROUP_NAME, 'FT2', count(*))) FT2,

    (decode(A.GROUP_NAME, 'AOI II', count(*))) AOI_II,

    (decode(A.GROUP_NAME, 'MAC COMPARE', count(*))) MAC_COMPARE,

    (decode(A.GROUP_NAME, 'ASY-1', count(*))) ASY_1,

    (decode(A.GROUP_NAME, 'VISUAL INSPECT', count(*))) VISUAL_INSPECT

from 

    SFISM4.R_WIP_TRACKING_T a    

    where A.MO_NUMBER='005700000405-1'

group by A.MO_NUMBER, A.GROUP_NAME

輸出如下：
005700000405-1    20                        
005700000405-1        4                    
005700000405-1            1                
005700000405-1                9            
005700000405-1                    4        
005700000405-1                            
005700000405-1                        2    
005700000405-1                            18
------解决方案--------------------
或是把几个decode合并，用一个decode就行了

decode(A.GROUP_NAME , 'ICT', A.PASS_QTY, 'ICT1', A.PASS_QT, 'ICT3', A.PASS_QTY)