แท็ก Wikis ที่มีการแก้ไขมากที่สุด ไม่จำเป็นต้องใช้ตารางทั้งหมด
Tag Wikis with the Most Edits.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT P.Id, SUBSTRING(P.Body, 0, 80), (SELECT COUNT(V.Id) FROM Votes AS V WHERE V.PostId = P.Id AND V.VoteTypeId = 16) AS "edits", CAST(TIME_TO_STR(P.CommunityOwnedDate, '%b %d, %Y') AS TEXT(12)), CAST(TIME_TO_STR(P.LastActivityDate, '%b %d, %Y') AS TEXT(12)) FROM Posts AS P, PostTypes AS Pt, Votes AS V, VoteTypes AS Vt WHERE Pt.Id = 5 AND Vt.Id = 16 AND P.Id = V.PostId AND Vt.Id = V.VoteTypeId AND Pt.Id = P.PostTypeId AND (SELECT COUNT(V.Id) FROM Votes AS V WHERE V.PostId = P.Id AND V.VoteTypeId = 16) > 50 GROUP BY P.Id, P.Body, P.CommunityOwnedDate, P.LastActivityDate ORDER BY Edits