Number of questions in a review queue per day

1

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT TOP(##num?100##)
CreationDate,
COUNT(PostId)
---since the table ReviewTasks contains only date, we don't get any information about hours/minutes
FROM ReviewTasks
WHERE (ReviewTaskTypeId=##type?2##) AND (CreationDate >= '##Date1?2020-01-01##') AND (CreationDate <= '##Date2?2020-03-01##')
---1 = Suggested Edit
---2 = Close Votes
---3 = Low Quality Posts
---4 = First Post
---5 = Late Answer
---6 = Reopen Vote
GROUP BY CreationDate
ORDER BY CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results