{code:SQL}
SELECT NO,SUM(TOT*DECODE(NO-LINE,1,-1,3,-1,1) ) TOT
,SUM(W01*DECODE(NO-LINE,1,-1,3,-1,1)) "1 월"
,SUM(W02*DECODE(NO-LINE,1,-1,3,-1,1)) "2 월"
,SUM(W03*DECODE(NO-LINE,1,-1,3,-1,1)) "3 월"
,SUM(W04*DECODE(NO-LINE,1,-1,3,-1,1)) "4 월"
,SUM(W05*DECODE(NO-LINE,1,-1,3,-1,1)) "5 월"
,SUM(W06*DECODE(NO-LINE,1,-1,3,-1,1)) "6 월"
,SUM(W01*DECODE(NO-LINE,1,-1,3,-1,1)) "7 월"
,SUM(W02*DECODE(NO-LINE,1,-1,3,-1,1)) "8 월"
,SUM(W03*DECODE(NO-LINE,1,-1,3,-1,1)) "9 월"
,SUM(W04*DECODE(NO-LINE,1,-1,3,-1,1)) "10 월"
,SUM(W05*DECODE(NO-LINE,1,-1,3,-1,1)) "11 월"
,SUM(W06*DECODE(NO-LINE,1,-1,3,-1,1)) "12 월"
FROM(SELECT LINE, SUM(AMT) TOT,
SUM(DECODE(MM,'01',AMT)) W01, SUM(DECODE(MM,'02',AMT)) W02,
SUM(DECODE(MM,'03',AMT)) W03, SUM(DECODE(MM,'04',AMT)) W04,
SUM(DECODE(MM,'05',AMT)) W05, SUM(DECODE(MM,'06',AMT)) W06,
SUM(DECODE(MM,'07',AMT)) W07, SUM(DECODE(MM,'08',AMT)) W08,
SUM(DECODE(MM,'09',AMT)) W09, SUM(DECODE(MM,'04',AMT)) W10,
SUM(DECODE(MM,'11',AMT)) W11, SUM(DECODE(MM,'06',AMT)) W12
FROM(SELECT Y.NO LINE, MM, SUM(AMT*DECODE(Y.NO*LINE,6,-1,1) ) AMT
FROM(SELECT '1' LINE, SUBSTR(S2.YYMM ,5,2) MM, SUM(AMT) AMT
FROM SALE_SUMM2 S2
WHERE S2.YYMM LIKE '1997%'
GROUP BY SUBSTR(S2.YYMM,5,2)
UNION ALL
SELECT '2' LINE, SUBSTR(SW.YYMM ,5,2) MM, SUM(AMT) AMT
FROM SALE_WONGA SW
WHERE SW.YYMM LIKE '1997%'
GROUP BY SUBSTR(SW.YYMM ,5,2)) X, COPY_T Y
WHERE Y.NO IN (LINE, 3)
AND Y.NO <= 14
GROUP BY Y.NO, MM
UNION ALL
SELECT Y.NO LINE, MM, SUM(AMT*DECODE(Y.NO*LINE,88,-1,1) ) AMT
FROM(SELECT DECODE(SUBSTR(SL.ACCOUNT ,1,3),'211',4, '212',5,
'213',6, '214',7, '215',8, '221',9, '222',10, 13) LINE,
SUBSTR(SL.YYMM,5,2) MM, SUM(AMT) AMT
FROM SLIP_SUMM SL
WHERE SL.YYMM LIKE '1997%'
AND SL.ACCOUNT BETWEEN '211' AND '229'
GROUP BY DECODE(SUBSTR(SL.ACCOUNT,1,3),'211',4, '212',5,
'213',6, '214',7, '215',8, '221',9, '222',10, 13),
SUBSTR(SL.YYMM,5,2)) X, COPY_T Y
WHERE Y.NO IN ( LINE,DECODE(LINE,13,NULL,11) ) AND Y.NO <=14
GROUP BY Y.NO, MM)
GROUP BY LINE) X, COPY_T Y
WHERE Y.NO IN (LINE, DECODE(LINE,3,12, 11,12), DECODE(LINE,3,14,11,14,13,14))
AND Y.NO <= 14
GROUP BY Y.NO;