Number of active users in a set of tags month wise


Please login or register to vote for this query.

(click on this box to dismiss)

A user is considered "active" if they have > "threshhold" posts in the given set of tags, where "threshhold" is a parameter that can be set by modifying the textbox below.

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

select count(distinct Posts.owneruserid)  
from posts , PostTags, Tags
where PostTags.PostId = Posts.Id and Tags.Id = PostTags.TagId 
and Posts.CreationDate - GETUTCDATE()<60
and Tags.TagName like '%javascript'

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results