Suggested edit statistics per day


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  Count(*) AS [Suggested],
  Count(ALL se.ApprovalDate) AS [Accepted],
  Round(100.0 * Count(ALL se.ApprovalDate) / Count(*), 2) AS [Accepted %],
  Count(*) - Count(ALL NullIf(p.PostTypeId, 4)) AS [Excerpts],
  Count(*) - Count(ALL NullIf(p.PostTypeId, 5)) AS [Wikis],
  Cast(se.CreationDate AS date) AS [Date]
FROM SuggestedEdits se, Posts p
WHERE se.PostId = p.Id
GROUP BY Cast(se.CreationDate AS date)
ORDER BY Cast(se.CreationDate AS date)

Enter Parameters

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