Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for scientific skepticism

SELECT t.TagName,
DatePart(quarter, p.LastActivityDate) AS q, Year(p.LastActivityDate) AS y, 
COUNT(p.Id) As NumPosts, COUNT(t.TagName)
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON t.Id = pt.TagId
WHERE Year(p.LastActivityDate) >= 2014
  AND p.LastActivityDate < '7/1/2016'
GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), t.TagName
HAVING COUNT(p.Id) > 1000
ORDER BY y, q, NumPosts DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results