select Year(CreationDate) AS [Year], Month(CreationDate) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select 
    Year(CreationDate) AS [Year], 
    Month(CreationDate) AS [Month], 
    count(*), 
    Sum(ViewCount) AS [ViewCount], 
    Sum(AnswerCount) AS [AnswerCount], 
    Sum(CommentCount) AS [CommentCount]
from Posts
group by Year(CreationDate), Month(CreationDate)

Enter Parameters

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