0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/273645/trends-on-stack-overflow

Q&A for professional and enthusiast programmers

select datediff(w, p.creationdate, getdate())
     , count(*) [Python]
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where tagname = 'python'
group by datediff(w, p.creationdate, getdate())

view current version

edited feb 27 16

created feb 27 16 rene