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)

GIS

Q&A for cartographers, geographers and GIS professionals

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 meta site
loading Hold tight while we fetch your results