instruction: Most popular mobile technologies in 2016.
response: SELECT num.TagName AS Tag, rate.Rate AS QuestionsInOctober, 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-01-01' AND Posts.CreationDate > '2016-12-31' 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) AS num ON rate.TagName = num.TagName ORDER BY rate.rate DESC