SELECT ENV,JAHR,KW,'0000' as MONDAY,RESTYPE,SUM(AMOUNT) as AMOUNT 

  FROM CCDCRESA where ENV=:ENV and RESTYPE=:RESTYPE 

 GROUP BY ENV,RESTYPE,JAHR,KW,RESTYPE 

 ORDER BY ENV,JAHR,KW asc