Total edits

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(posts.creationdate), month(posts.creationdate), day(posts.creationdate)), 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(posts.creationdate), month(posts.creationdate), day(posts.creationdate))
order by datefromparts(year(posts.creationdate), month(posts.creationdate), day(posts.creationdate))

Enter Parameters

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