แท็กที่ใช้บ่อยที่สุดระหว่าง ม.ค.-15 พ.ย.-58 ไม่จำเป็นต้องใช้ทุกตาราง
Most used tags between Jan-15 Nov-15.It is not neccessary to use all the tables.
 PostHistory:  Id [ number]  PostHistoryTypeId [ number]  PostId [ number]  RevisionGUID [ other]  CreationDate [ time]  UserId [ number]  UserDisplayName [ text]  Comment [ text]  Text [ text]  ContentLicense [ text] 
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 Questions14, 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 < '2015-11-23' AND Posts.CreationDate > '2015-01-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