Show how long reviews take on average, sorted by review type.
The review durations are averaged over a calendar week and shown in minutes.
WARNING: this query is probably buggy! http://data.stackexchange.com/cs/query/199807/suggested-edit-weekly-statistics has a more correct-looking query for suggested edits only.
Q&A about the site for gardeners and landscapers
Convert(varchar(10), DateAdd(Day, DateDiff(Day, 0, RT.CreationDate) / 7 * 7, '1900-01-01'), 126) AS [Week from],
Avg(DateDiff(Minute, RT.CreationDate, RT.DeletionDate)) AS [All]
FROM ReviewTasks RT
GROUP BY DateDiff(Day, 0, RT.CreationDate) / 7
ORDER BY [Week from] ASC