zOs/SQL/PDBGENRR

SELECT
WEEK(TIMESTAMP) AS WEEK
,DEC(SUM(OCCURRENCES),25,0) AS OCCURRENCES
,DEC(SUM(CLASS1_ELAPSED),25,0) AS CLASS1_ELAPSED
,DEC(SUM(CLASS1_CPU_TOTAL),25,0) AS CLASS1_CPU_TOTAL
,DEC(SUM(CLASS2_ELAPSED),25,0) AS CLASS2_ELAPSED
,DEC(SUM(CLASS2_CPU_TOTAL),25,0) AS CLASS2_CPU_TOTAL
FROM RZ2DD.TACCT_GENERAL
WHERE TIMESTAMP >= '2010-05-10-00.00.00.000000'
AND TIMESTAMP <= '2010-07-15-00.00.00.000000'
AND CORRNAME LIKE 'QR%'
GROUP BY WEEK(TIMESTAMP)
ORDER BY WEEK DESC