0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT --year(p.CreationDate) yr, month(p.CreationDate) yr_month, 
       count(*) questions
FROM Posts p, PostTags pt, Tags t
WHERE 1=1
AND p.id = pt.PostId
AND t.id = pt.TagId
AND t.TagName = ##tag:string?weka##
GROUP BY year(p.CreationDate), month(p.CreationDate)
order by year(p.CreationDate), month(p.CreationDate)

view current version

edited jan 12 15 David Marx

created jan 12 15 anonymous