Comment count for high-rep users by day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

SELECT YEAR(c.CreationDate)*100 + MONTH(c.CreationDate) As YearMonth, Count(c.Id) As CountOfComments
FROM Comments c
INNER JOIN Users u ON c.UserId = u.Id
WHERE u.Reputation > ##HighRepBorder:int##
GROUP BY YEAR(c.CreationDate)*100 + MONTH(c.CreationDate)
ORDER BY YEAR(c.CreationDate)*100 + MONTH(c.CreationDate)

Enter Parameters

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