instruction: Most popular recent StackOverflow tags.
response: SELECT LEFT(t.TagName, 8) AS Tag, TIME_TO_STR(p.CreationDate, 'Q') AS q, YEAR(p.CreationDate) AS y, COUNT(p.Id) AS NumPosts FROM Tags AS t JOIN PostTags AS pt ON pt.TagId = t.Id JOIN Posts AS p ON p.Id = pt.PostId WHERE (t.TagName LIKE 'python-2%' OR t.TagName LIKE 'python-3%') AND YEAR(p.CreationDate) >= 2012 GROUP BY LEFT(t.TagName, 8), TIME_TO_STR(p.CreationDate, 'Q'), YEAR(p.CreationDate) ORDER BY y, q, Tag DESC