DECLARE @TOTAL_REQUESTS as INT
SET @TOTAL_REQUESTS = (SELECT	
COUNT(MG.[ID]) as 'Всего выполнено'
											
  FROM [dbo].[MYGROUPSM1] MG
  LEFT JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
  LEFT JOIN [dbo].[SCRELATIONM1] SC on IM.INCIDENT_ID = SC.SOURCE
  where    MEMBER_OF like '%Группа операторов СД%'
  and IM.DDC_RESOLVE_TIME IS NOT NULL
 and im.FOLDER ='EGK'
and  (OPEN_TIME >=  (@StartDate) and OPEN_TIME < (@EndDate+1))
group by [ID]
)


SELECT [ID],
       CASE WHEN sum(T1) > 0 THEN sum(T1)*1
	   ELSE 0
	   END  Table1,

       CASE WHEN sum(T2) > 0 THEN sum(T2)*1
	   ELSE 0
	   END  Table2,

	   CASE WHEN sum(T3) > 0 THEN sum(T3)*1
	   ELSE 0
	   END  Table3,

	   CASE WHEN sum(T4) > 0 THEN sum(T4)*1
	   ELSE 0
	   END  Table4
  FROM (

SELECT [ID], 
COUNT(MG.[ID]) - COUNT(SC.SOURCE) as T1, 0 as T2,0 as T3,0 as T4, 
COUNT(MG.[ID]) - COUNT(SC.SOURCE) as 'Выполненные самостоятельно'
						
  FROM [dbo].[MYGROUPSM1] MG
  LEFT JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
  LEFT JOIN [dbo].[SCRELATIONM1] SC on IM.INCIDENT_ID = SC.SOURCE
  where    MEMBER_OF like '%Группа операторов СД%'
  and IM.DDC_RESOLVE_TIME IS NOT NULL
 and im.FOLDER ='EGK'
and  (OPEN_TIME >=  (@StartDate) and OPEN_TIME < (@EndDate+1))
group by [ID]

UNION ALL

SELECT [ID], 	
0 as T1, 1 as T2, 0 as T3,0 as T4, 
COUNT(SC.SOURCE) as 'Эскалированные'
											
  FROM [dbo].[MYGROUPSM1] MG
  LEFT JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
  LEFT JOIN [dbo].[SCRELATIONM1] SC on IM.INCIDENT_ID = SC.SOURCE
  where    MEMBER_OF like '%Группа операторов СД%'
  and IM.DDC_RESOLVE_TIME IS NOT NULL
 and im.FOLDER ='EGK'
and  (OPEN_TIME >=  (@StartDate) and OPEN_TIME < (@EndDate+1))
group by [ID]


  UNION ALL
SELECT [ID], 	
0 as T1, 0 as T2, 0 as T3,@TOTAL_REQUESTS as T4, 
@TOTAL_REQUESTS as 'Всего выполнено'
											
  FROM [dbo].[MYGROUPSM1] MG
  LEFT JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
  LEFT JOIN [dbo].[SCRELATIONM1] SC on IM.INCIDENT_ID = SC.SOURCE
  where    MEMBER_OF like '%Группа операторов СД%'
  and IM.DDC_RESOLVE_TIME IS NOT NULL
 and im.FOLDER ='EGK'
and  (OPEN_TIME >=  (@StartDate) and OPEN_TIME < (@EndDate+1))
group by [ID]
  UNION ALL

select [ID],
0 as T1, 0 as T2, sum(cnt) as T3,0 as T4, 
sum(cnt)
from(

SELECT COUNT(*) AS cnt, [ID]
FROM [dbo].[MYGROUPSM1] MG
INNER JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
INNER JOIN [DBO].[REQUESTM1] R on R.DDC_INCIDENT_ID = IM.INCIDENT_ID
WHERE R.CLOSURE_CODE = 'Escalation Cancelled'
AND R.FOLDER = 'EGK'
and  (IM.OPEN_TIME >=  (@StartDate) and IM.OPEN_TIME < (@EndDate+1))
and MEMBER_OF like '%Группа операторов СД%'
group by [ID]

union all

SELECT COUNT(*) AS cnt, mg.[ID]
FROM [dbo].[MYGROUPSM1] MG
INNER JOIN [dbo].[INCIDENTSM1] IM on MG.ID = IM.ASSIGNEE
INNER JOIN [dbo].[PROBSUMMARYM1] P on P.INCIDENT_ID = IM.INCIDENT_ID
WHERE P.RESOLUTION_CODE = 'Escalation Cancelled'
AND P.FOLDER = 'EGK'
and  (IM.OPEN_TIME >=  (@StartDate) and IM.OPEN_TIME < (@EndDate+1))
and MEMBER_OF like '%Группа операторов СД%'
group by mg.[ID]

)as q
group by [ID]
  ) t
 GROUP BY [ID]
 ORDER BY 1 desc