Q&A for users and developers of the Cardano cryptocurrency ecosystem
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