Q&A for designers and implementers of computer programming languages
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