Number of Posts edited by > 1 user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

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
;

Enter Parameters

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