select year(p.creationDate) as y, count(DISTINCT p.id) as...

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) as y, count(DISTINCT p.id) as python 
from posts p 
join PostTags pTags on pTags.postId = p.id
join Tags t on t.id = pTags.tagId
-- where p.answerCount + p.commentCount > 0 
where t.tagName in ('python', 'python-3.x', 'python-2.7')
group by year(p.creationDate)
order by year(p.creationDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results