Edits over time (month-by-month)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  datefromparts(year(posthistory.creationdate),
                month(posthistory.creationdate),
                1),
  count(*)
from Posts
join PostTypes on Posts.PostTypeId = PostTypes.Id
join PostHistory on Posts.id = PostHistory.PostId
join PostHistoryTypes on PostHistory.PostHistoryTypeId = PostHistoryTypes.Id
where
  PostTypes.Name in ('Question', 'Answer')
  and PostHistoryTypes.Name in ('Edit Title', 'Edit Body', 'Edit Tags')
group by datefromparts(year(posthistory.creationdate),
                       month(posthistory.creationdate),
                       1)
order by datefromparts(year(posthistory.creationdate),
                       month(posthistory.creationdate),
                       1)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results