Popularity of JavaScript frameworks for a given time period

0

Please login or register to vote for this query.

(click on this box to dismiss)

Count and rank of Ember.js, Knockout.js, Backbone.js, and Angular.js tags in the last month.

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select
       rate.TagName as Tag,
       row_number() over (order by rate.Rate desc) as Rank,
       rate.Rate as QuestionsTotal
from
(
select
  count(PostId) as Rate, TagName
from
  Tags, PostTags, Posts
where
  Tags.Id = PostTags.TagId and Posts.Id = PostId
  and Posts.CreationDate < GetDate()
  and Posts.CreationDate > DATEADD(month, -1, GetDate())
  and TagName in (
'django',
'tornado',
'flask',
'bottle',
'plone'
  )
  group by TagName
) as rate
order by rate.rate desc
;

Enter Parameters

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