จำนวนโพสต์ที่แก้ไขโดยผู้ใช้ > 1 คน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of Posts edited by > 1 user.It is not neccessary to use all the tables.
 Tags:  Id [ number]  TagName [ text]  Count [ number]  ExcerptPostId [ number]  WikiPostId [ number] 
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 NOT ApprovalDate IS NULL) AS PercentPostsWithAcceptedSuggestedEdits