select t.TASKRESP as 'MA-Kurzzeichen', CONCAT(us.USVORNAME,' ',us.USFAMILIENNAME) as NAME,

       ROUND(SUM(ESTEFFPH)) as SUMME_PLANSTUNDEN,

       (select ROUND(IFNULL(SUM(STUNDEN),0)) from CCILV where USKURZZ=t.TASKRESP and PSP like 'P.101.026%') as SUMME_ISTSTUNDEN, 

       (select MIN(0+MONAT) from CCILV where USKURZZ=t.TASKRESP and PSP like 'P.101.026%' and JAHR=2017) as VON_MONAT,

       (select MAX(0+MONAT) from CCILV where USKURZZ=t.TASKRESP and PSP like 'P.101.026%' and JAHR=2017) as BIS_MONAT,  

       SUM(FCESTEFFPH) as SUMME_FORECAST_STUNDEN

  from CCVTASKFC t

    left outer join CCUS us on us.USKURZZ=t.TASKRESP

 where t.PROJECT='ZPI2017' and t.TASKTYPE='TASK' and t.TASKRESP is not null

 group by TASKRESP, us.USVORNAME, us.USFAMILIENNAME