Most popular StackOverflow tags in May 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

select TOP 20 
  count(PostId) as Num, 
  TagName,
  DATENAME(month,Posts.CreationDate)as Month
from
  Tags
  inner join postTags on Tags.Id = PostTags.TagId
  inner join Posts on Posts.Id = PostId
where
  Posts.CreationDate > '2012-01-01' and 
  Posts.CreationDate < '2012-05-01'
group by 
  TagName, DATENAME(month,Posts.CreationDate)
order by Num desc;

Enter Parameters

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