with rubyPosts(id) as (select PostId from tags join PostT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

with rubyPosts(id) as (select PostId
from tags
  join PostTags
  on tags.Id = PostTags.TagId
where TagName LIKE 'dhtmlx%'),
owners(id, creation) as (select OwnerUserId, Min(CreationDate)
  from Posts
  where (Id in (select id from rubyPosts) or ParentID in (select id from rubyPosts))
  and CreationDate >= Convert(DATETIME, '2010-01-01')
  GROUP BY OwnerUserId)
(select COUNT(DISTINCT Users.Id) as numOfUsers, YEAR(owners.creation) as creationYear, MONTH(owners.creation) as creationMonth
from Users
join owners
  on Users.id = owners.id
where Reputation >= 10
GROUP BY YEAR(owners.creation), MONTH(owners.creation));

Enter Parameters

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