0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT year(Posts.ClosedDate) as y, month(Posts.ClosedDate) as m,  cast (year(Posts.ClosedDate) as  varchar(10)) + '/' + cast(month(Posts.ClosedDate) as varchar(19)) as ym,  count(CONCAT ('http://programmers.stackexchange.com/q/', Posts.Id)) as Questions
FROM PostHistory
JOIN Posts ON Posts.Id = PostHistory.PostId
WHERE Posts.ClosedDate >= '2012-01-01' 
--AND Posts.ClosedDate < '2012-12-01'
AND PostHistoryTypeId = 10
AND PostHistory.Comment != 1
group by year(Posts.ClosedDate), month(Posts.ClosedDate)
ORDER BY 1 desc, 2 desc

view current version

edited jan 26 13 knb

created nov 16 12 hairboat