SELECT
SGRT.[SkillTargetID]
,SG.EnterpriseName
,DefaultAvgHandledTime = SG_AHT.avghandletime
,[RouterCallsQNow]
,[AvgHandledCallsTimeTo5]
,[Ready]
,[TalkingIn]
,[TalkingOther]
,[TalkingOut]
,[RouterLongestCallInQ]
,AgentsTalking = (TalkingIn+TalkingOut+TalkingOther)
,CASE
WHEN [Ready] > (TalkingIn+TalkingOut+TalkingOther) THEN [Ready]
ELSE (TalkingIn+TalkingOut+TalkingOther)
END AS AgentCount
FROM
[vhi_awdb].[dbo].[Skill_Group_Real_Time] SGRT
LEFT JOIN Skill_Group SG ON SG.SkillTargetID = SGRT.SkillTargetID
JOIN skillgroup_avghandletime SG_AHT ON SGRT.SkillTargetID = SG_AHT.id
SELECT
ewtsg.skillgroup_id
,eg.name
,DefaultAvgHandledTime = SGAHT.avghandletime
,[RouterCallsQNow]
,[AvgHandledCallsTimeTo5]
,[Ready]
,[TalkingIn]
,[TalkingOther]
,[TalkingOut]
,[RouterLongestCallInQ]
,AgentsTalking = (TalkingIn+TalkingOut+TalkingOther)
FROM [ewtgroup_skillgroup] ewtsg
JOIN [ewtgroup] eg ON eg.id = ewtgroup_id
JOIN [Skill_Group_Real_Time] SGRT ON SGRT.SkillTargetID = ewtsg.skillgroup_id
LEFT JOIN [skillgroup_avghandletime] SGAHT ON SGAHT.id = ewtsg.skillgroup_id