0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  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)

fork query

edited may 22 12

created may 21 12 Gilles