แท็ก 10 อันดับแรกตามปี เดือน ตั้งแต่ปี 2010 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top 10 Tags by Year, Month Since 2010.It is not neccessary to use all the tables.
 PostTypes:  Id [ number]  Name [ text] 
SELECT * FROM (SELECT YEAR(CreationDate) AS CreationYear, MONTH(CreationDate) AS CreationMonth, TagName, COUNT(PostId) AS PostCount, RANK() OVER (PARTITION BY YEAR(CreationDate), MONTH(CreationDate) ORDER BY COUNT(PostId) DESC) AS Rank FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.Tags LIKE '%<windows-phone%' GROUP BY YEAR(CreationDate), MONTH(CreationDate), TagName) AS TagPostRankings WHERE Rank <= 10 AND CreationYear >= 2010 ORDER BY CreationYear, CreationMonth, Rank