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