1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

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

fork query

created sep 12 23 Michael42742