Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT sub.NumQuestions, sub.Uid as [User Link], sub.Reputation, sub.CreationDate FROM ( select count(u.id) as NumQuestions, p.OwnerUserId as Uid, u.Reputation, u.CreationDate from Posts p left join Users u on u.Id = p.OwnerUserId where p.PostTypeId = 1 AND u.Reputation < ##RepThreshold?50## group by p.OwnerUserId, u.Reputation, u.CreationDate ) sub WHERE NumQuestions > ##NumQuestionsThreshold?20##