0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scientists using computers to solve scientific problems

SELECT top 100 t.tagname,count(*)
FROM TAGS t
JOIN PostTags tb ON tb.tagid = t.id
JOIN (SELECT li.id
FROM Posts li
JOIN PostTags tb ON tb.PostId = li.id
JOIN TAGS t ON t.id = tb.tagid
WHERE t.tagname = 'javascript'
and 
li.CreationDate < '2018-10-01' and 
li.CreationDate > '2018-06-01'
) x ON x.id = tb.PostId

GROUP BY t.tagname
order by count(*) desc

view current version

edited sep 26 18

created sep 26 18 anonymous