Most popular StackOverflow tags in May 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select count(distinct PostId) as Rate, 
    'java' as tag,
    TagName, 
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and tagName in ( 'java', 'java-me', 'java-ee', 'javafx', 'javafx-2')
group by TagName, dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
union
select count(distinct PostId) as Rate, 
    'python' as tag,
    TagName, 
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and (tagName like 'python%' or tagname like 'django')
group by TagName, dateadd(month, datediff(month, 0, Posts.CreationDate),0)

Enter Parameters

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