0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer enthusiasts and power users

select dateadd(month, datediff(month, 0, CreationDate), 0), Sum(Score) NetQuestionScore
from Posts
where PostTypeId=1
group by dateadd(month, datediff(month, 0, CreationDate), 0)
order by dateadd(month, datediff(month, 0, CreationDate), 0)

view current version

edited aug 1 16

created aug 1 16 anonymous