question times by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT year(p.CreationDate) +
       (month(p.CreationDate)-1) /12. yr_month, 
       TagName,
       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 = ##tag1:string?python##
  or t.TagName = ##tag2:string?-##
  or t.TagName = ##tag3:string?-##
  or t.TagName = ##tag4:string?-##
  or t.TagName = ##tag5:string?-##)
--AND year(p.CreationDate) < 2015
GROUP BY year(p.CreationDate), month(p.CreationDate), tagname
order by year(p.CreationDate), month(p.CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results