1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT -- TOP 20
t.TagName,year(p.CreationDate) as Year, month(p.CreationDate) as Month, count(t.TagName) AS TagCount FROM Tags AS t 
INNER JOIN Posttags pt ON t.Id = pt.TagId
INNER JOIN Posts P ON p.Id = pt.PostId
where t.TagName = '##TagNam##'

GROUP BY year(p.CreationDate), month(p.CreationDate), t.TagName
order by year(p.CreationDate), month(p.CreationDate)

fork query

edited oct 16 19

created oct 16 19 m98