Maybe a different cutoff value for the number of posts or a changed ordering would be preferable.
Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools
with percentages as ( select users.Id as UserId, count(posts.Id) as Posts, sum(posts.score) * 1.0 / count(posts.Id) as AvgScore, users.Reputation as UserReputation from users left outer join posts on users.Id = posts.OwnerUserId where posts.PostTypeId = 2 group by users.Id, users.Reputation ) select top 1000 UserId as [User Link], UserReputation, Posts, round(AvgScore, 1) as [Average Score] from percentages where Posts >= 10 order by AvgScore desc;