Close vote review task results per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT
  eomonth(r.Creationdate), COUNT(r.Id)
FROM ReviewTaskResults r
inner join ReviewTasks t on t.id = r.ReviewTaskId 
WHERE t.ReviewTaskTypeId=2
GROUP BY eomonth(r.Creationdate)
ORDER BY eomonth(r.Creationdate) ASC
--We are count only close votes review: ReviewTaskTypeId=2

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results