Q&A for developers and researchers interested in open data
DECLARE @totalPosts DECIMAL SELECT @totalPosts = COUNT(*) FROM posts; Select ( Select (100.0 * Count(*) / @totalPosts) As PercentPostsEditedSeveralTimes FROM ( Select Count(*) AS NumRevisions From PostHistory Group By PostId ) As Revisions Where Revisions.NumRevisions > 1 ) As PostsEditedSeveralTimes, ( Select 100.0 * Count(*) / @totalPosts As PercentPostsEditedBySeveralUsers FROM ( Select Count(Distinct UserId) as NumUsers From PostHistory Group By PostId ) As Revisions Where Revisions.NumUsers > 1 ) As PostsEditedBySeveralUsers, ( Select 100.0 * Count(Distinct(PostId)) / @totalPosts From SuggestedEdits Where ApprovalDate IS NOT NULL ) As PercentPostsWithAcceptedSuggestedEdits ;