instruction: Python 2.x vs. Python 3.x - Number of Questions - Quarterly. The goal of this query is to compare the trend of the number of Python 2 vs. Python 3 related questions. I started with 2012, because there were very few questions before that.
  
  For more information on the purpose of the query, see https://www.webucator.com/blog/2016/03/still-using-python-2-it-is-time-to-upgrade/.
response: SELECT LEFT(t.TagName, 8) AS Tag, 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), YEAR(p.CreationDate) ORDER BY y, Tag DESC