select top 50000 qd.QUEUENAME "Group",convert(varchar(10),(avg(wo.completedtime)-avg(wo.createdtime))/1000/3600)+':'+convert(varchar(10),((avg(wo.completedtime)-avg(wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((avg(wo.completedtime)-avg(wo.createdtime)))/1000%60)) "Avg Resolution Time" FROM WorkOrder wo LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE (wo.ISPARENT='1') and completedtime!=0 and qd.QUEUENAME like '%Call Center%'  and 

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') >= convert(varchar,'2016-05-01 00:00',21) and 

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') <= convert(varchar,'2016-05-31 23:59',21)  group by qd.QUEUENAME