Q&A for meta-discussion of the Stack Exchange family of Q&A websites
-- Enter Query Title -- Enter Query Description SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'django' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'python' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'ruby-on-rails' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'ruby' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = '.net' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'c#' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'java' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'jquery' GROUP BY t.TagName, YEAR(p.CreationDate) UNION ALL SELECT posts = count(p.Id), tag = t.TagName, year = YEAR(p.CreationDate) FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'javascript' GROUP BY t.TagName, YEAR(p.CreationDate)