Most popular StackOverflow tags in May 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Most popular StackOverflow tags in May 2010

DECLARE @Table TABLE (Col1 INT, Col2 DATETIME)
DECLARE @start DATETIME, @end DATETIME

SET @start =  '2009-05-01'
SET @end =  '2010-06-01'

WHILE @start < '2013-06-01'

BEGIN
select 
       rate.Rate as QuestionsInMonth

from

(select count(PostId) as Rate, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId and Tags.TagName = 'android'
and Posts.CreationDate between @start and @end
group by TagName) as rate

INNER JOIN

(select count(PostId) as Num, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
group by TagName
having count(PostId) > 800)
as num ON rate.TagName = num.TagName
order by rate.rate desc

SET @start = DATEADD(MONTH,1,@start)
SET @end = DATEADD(MONTH,1,@end)
END

Enter Parameters

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