Votes on which day after posting

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT
DATEDIFF(day, p.CreationDate, v.CreationDate) AS Days,
  COUNT(v.Id) AS Count
FROM Votes v INNER JOIN Posts p ON v.PostId=p.Id
GROUP BY DATEDIFF(day, p.CreationDate, v.CreationDate) 
ORDER BY DATEDIFF(day, p.CreationDate, v.CreationDate)

Enter Parameters

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