0

Please login or register to vote for this query.

(click on this box to dismiss)

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
  UserId as [User Link],
  UserReputation,
  Posts,
  round(AvgScore, 1) as [Average Score]
from percentages
where Posts >= 10
order by AvgScore desc;

fork query

edited dec 30 15 anonymous

created jul 14 10 sth