--Seven - All Service Request WIs By Category
WITH WorkItem as (
	SELECT
		DisplayString_Category.DisplayName as Category
		,ServiceRequest.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C as WOrkItemId
		,ServiceRequest.CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688 as Created
		--,COUNT(Distinct ServiceRequest.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C) as SRCount
	FROM ServiceManager_UAT.dbo.MTV_System$WorkItem$ServiceRequest as ServiceRequest

	inner join DisplayStringView as DisplayString_Category
		on DisplayString_Category.LTStringId = ServiceRequest.SA_Category_83B1DF2D_A1EB_FF58_13D9_D26629BFB0E1
		AND DisplayString_Category.LanguageCode = 'ENU'

	WHERE @createdFilter

)

select
	Category
	,COUNT(Distinct WorkItem.WorkItemId) as SRCount
	from WorkItem

	Group By Category
ORDER BY SRCount DESC