0

Please login or register to vote for this query.

(click on this box to dismiss)

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)

fork query

created dec 29 10 anonymous