แท็ก StackOverflow ที่ได้รับความนิยมมากที่สุดในเดือนกรกฎาคม 2559 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most popular StackOverflow tags July2016.It is not neccessary to use all the tables.
 SuggestedEditVotes:  Id [ number]  SuggestedEditId [ number]  UserId [ number]  VoteTypeId [ number]  CreationDate [ time]  TargetUserId [ number]  TargetRepChange [ number] 
SELECT num.TagName AS Tag, ROW_NUMBER() OVER (ORDER BY rate.Rate DESC) AS MayRank, ROW_NUMBER() OVER (ORDER BY num.Num DESC) AS TotalRank, rate.Rate AS QuestionsInMay, num.Num AS QuestionsTotal FROM (SELECT COUNT(PostId) AS Rate, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.CreationDate < '2016-10-13' AND Posts.CreationDate > '2016-10-01' GROUP BY TagName) AS rate INNER JOIN (SELECT COUNT(PostId) AS Num, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId GROUP BY TagName HAVING COUNT(PostId) > 800) AS num ON rate.TagName = num.TagName ORDER BY rate.rate DESC