SQL - Sistemin 6 aylık saatlere göre yoğunluğunu alan kod

select

	DATEPART(HOUR,DATEADD(HOUR,3,wi.EndDate)) as 'Saat',
	count(1) 'Kayıt Sayısı'

from wflInstances i (nolock)
inner join wflWorkItems wi (nolock) on i.Id = wi.Instance 
										and wi.EndDate is not null 
										and convert(varchar(10),(wi.EndDate),120) > CONVERT(varchar(10),getdate()-60 /*Son 60 güne ait */ ,120)
group by  DATEPART (HOUR,DATEADD(HOUR,3,wi.EndDate)) 
order by 'Saat',[Kayıt Sayısı]  desc