问SQL查询最近8周的请求总数

EN

Declare @DatePeriod DATETIME = GETUTCDATE()

Select  IsNull([1],0) as 'Week 1',
        IsNull([2],0) as 'Week 2',
        IsNull([3],0) as 'Week 3',
        IsNull([4],0) as 'Week 4',
        IsNull([5],0) as 'Week 5',
        IsNull([6],0) as 'Week 6',
        IsNull([7],0) as 'Week 7',
        IsNull([8],0) as 'Week 8'
From 
(
Select  
        DATEDIFF(week, DATEADD(MONTH, DATEDIFF(MONTH, 0, createdDate), 0), createdDate) +1 as [Weeks],
        COUNT(reqID) as 'TotalOpened'

From support_tickets
Where DatePart(Month, createdDate)= DatePart(Month, @DatePeriod)
AND tool = 244
)p 
Pivot (COUNT(TotalOpened) for Weeks in ([1],[2],[3],[4],[5],[6],[7],[8])) as pv

Column 'support_tickets.createdDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.