select JAHR as "Jahr", count(KW) as "Anzahl Wochen", count(IN_LADEBESTAENDEN) as "Anzahl Ladebestände", 
       min(KW) as "Erste Kalenderwoche", max(KW) as "Letzte Kalenderwoche",
       min(IN_LADEBESTAENDEN) as "Erster Ladebestand", max(IN_LADEBESTAENDEN) as "Letzter Ladebestand"
  from (select JAHR, KW, wm_concat(distinct LOADNAME) as IN_LADEBESTAENDEN, 
               (select wm_concat(count(*)) from CCDCRESA d where d.JAHR=dcr.JAHR and d.KW=dcr.KW group by d.JAHR, d.KW, d.LOADNAME) as LADEBESTANDGROESSEN 
          from CCDCRESA dcr 
         group by JAHR, KW 
         order by JAHR, KW asc) 
 group by JAHR
 order by JAHR asc