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.

Open Source

Q&A for people organizing, marketing or licensing open source development projects

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 to meta site
loading Hold tight while we fetch your results