Q&A for pro webmasters
; with spam_cte as (SELECT DISTINCT p.Id AS pid, DATEDIFF(minute, p.CreationDate, p.DeletionDate) AS Minutes, p.CreationDate AS cre, p.DeletionDate AS del FROM PostsWithDeleted p INNER JOIN Votes v ON v.PostId=p.Id WHERE v.VoteTypeId=##votetype?12## AND (p.DeletionDate IS NOT NULL)) SELECT DATEADD(dd, -(DATEPART(dw, cre)-1), CAST(cre AS Date)) [WeekStart], AVG(Minutes) AS [Average] FROM spam_cte GROUP BY DATEADD(dd, -(DATEPART(dw, cre)-1), CAST(cre AS Date)) ORDER BY DATEADD(dd, -(DATEPART(dw, cre)-1), CAST(cre AS Date))