Number of users by year with at least N questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

with usersWithQuestions as
(
    select u.id, u.creationDate, count(*) answers
    from
      users u
      inner join posts p on p.ownerUserId = u.id
    where 
      postTypeId = 1 --question      
    group by
      u.id, u.creationDate
)
select
  year(creationDate) joinYear, count(*)
from
  usersWithQuestions
where 
  answers > ##NumberOfQuestions:int##
group by
  year(creationDate)
order by
  joinYear

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results