แท็ก StackOverflow ที่ได้รับความนิยมสูงสุดต่อเดือน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most popular StackOverflow tags per month.It is not neccessary to use all the tables.
 ReviewTaskStates:  Id [ number]  Name [ text]  Description [ text] 
SELECT num.TagName AS Tag, rate.Rate AS QuestionsPerMonth FROM (SELECT COUNT(PostId) AS Rate, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.CreationDate > '2015-02-01' AND Posts.CreationDate < '2015-03-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) > 100) AS num ON rate.TagName = num.TagName ORDER BY rate.rate DESC