SELECT
CASE WHEN ct.EnterpriseName LIKE 'TTK_UL_%' THEN 'Юридические лица' ELSE CASE WHEN ct.EnterpriseName LIKE '%West_Sib%' THEN 'Западная Сибирь' ELSE 'Физические лица' END END AS Region

, 100*ROUND(CAST(SUM(ISNULL(cti.AnsInterval1,0)+ISNULL(cti.AnsInterval2,0)+ISNULL(cti.AnsInterval3,0)+ISNULL(cti.AnsInterval4,0)) AS FLOAT)/(SUM(ISNULL(cti.CallsOffered,0))-SUM(ISNULL(cti.AbandInterval1,0)+ISNULL(cti.ShortCalls,0))),4) AS SL
, 100*ROUND(CAST(SUM(ISNULL(cti.TotalCallsAband,0)+ISNULL(cti.IncompleteCalls,0)-ISNULL(cti.AbandInterval1,0)) AS FLOAT)/(SUM(ISNULL(cti.CallsOffered,0))-SUM(ISNULL(cti.AbandInterval1,0)+ISNULL(cti.ShortCalls,0))),4) AS LCR
, SUM(ISNULL(cti.AnswerWaitTime,0))/SUM(ISNULL(cti.CallsAnswered,0)) AS ASA
FROM msk_pawhds..t_Call_Type AS ct (NOLOCK)
LEFT JOIN msk_pawhds..t_Call_Type_Interval AS cti ON cti.CallTypeID = ct.CallTypeID AND cti.DateTime >= CAST(GETDATE() AS DATE)
WHERE ct.EnterpriseName LIKE 'TTK%'
AND ct.EnterpriseName NOT IN ('TTK_Coach_IN..CT','TTK_Coach2_IN..CT','TTK_Supervisor_IN..CT','TTK_Transfer_VTM_IN..CT')
GROUP BY CASE WHEN ct.EnterpriseName LIKE 'TTK_UL_%' THEN 'Юридические лица' ELSE CASE WHEN ct.EnterpriseName LIKE '%West_Sib%' THEN 'Западная Сибирь' ELSE 'Физические лица' END END
), T2 AS (
SELECT
CASE WHEN ct.EnterpriseName LIKE 'TTK_UL_%' THEN 'Юридические лица' ELSE CASE WHEN ct.EnterpriseName LIKE '%West_Sib%' THEN 'Западная Сибирь' ELSE 'Физические лица' END END AS Region
, SUM(ctrt.RouterCallsQNow) AS Queue
FROM msk_pawhds..t_Call_Type AS ct (NOLOCK)
LEFT JOIN [172.16.32.18].pmsk_awdb.dbo.Call_Type_Real_Time AS ctrt ON ctrt.CallTypeID = ct.CallTypeID
WHERE ct.EnterpriseName LIKE 'TTK%'
AND ct.EnterpriseName NOT IN ('TTK_Coach_IN..CT','TTK_Coach2_IN..CT','TTK_Supervisor_IN..CT','TTK_Transfer_VTM_IN..CT')
GROUP BY CASE WHEN ct.EnterpriseName LIKE 'TTK_UL_%' THEN 'Юридические лица' ELSE CASE WHEN ct.EnterpriseName LIKE '%West_Sib%' THEN 'Западная Сибирь' ELSE 'Физические лица' END END
)

SELECT T1.*, T2.Queue FROM T1
LEFT JOIN T2 ON T2.Region = T1.Region
END