แท็ก GIS ยอดนิยมปี 2017 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most popular GIS tags 2017.It is not neccessary to use all the tables.
 PostFeedback:  Id [ number]  PostId [ number]  IsAnonymous [ boolean]  VoteTypeId [ number]  CreationDate [ time] 
SELECT rate.TagName AS Tag, ROW_NUMBER() OVER (ORDER BY rate.Rate DESC) AS Rank, rate.Rate AS Questions FROM (SELECT COUNT(PostId) AS Rate, TagName FROM Tags, PostTags, Posts WHERE Tags.Id = PostTags.TagId AND Posts.Id = PostId AND Posts.CreationDate < '2017-06-01' AND Posts.CreationDate > '2017-01-01' GROUP BY TagName) AS rate ORDER BY rate.rate DESC