Votes Over Time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the number of votes cast each day since the beginning of the site.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT CAST(v.CreationDate AS DATE) AS [Date],
       ISNULL(COUNT(CAST(v.CreationDate AS DATE)), 0) AS [Votes],
       ISNULL(COUNT(CAST(p.CreationDate AS DATE)), 0) AS [Posts]
FROM Votes v
INNER JOIN Posts p ON CAST(v.CreationDate AS DATE) = CAST(p.CreationDate AS DATE)
WHERE VoteTypeId = ##VoteType:int?2##
GROUP BY CAST(v.CreationDate AS DATE)
ORDER BY CAST(v.CreationDate AS DATE)

Enter Parameters

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