View to question conversion last month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Not possible to do without a historic database

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
 (datepart(yy, p.creationdate) + (datepart(mm, p.creationdate)-1) / 12.0) as YR_MON,
 count(*)
FROM Posts p
WHERE p.PostTypeId = 1
and p.score>0
GROUP BY (datepart(yy, p.creationdate) + (datepart(mm, p.creationdate)-1) / 12.0)
ORDER BY (datepart(yy, p.creationdate) + (datepart(mm, p.creationdate)-1) / 12.0)

Enter Parameters

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