Users with many upvoted posts, but low average score

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.

GenAI Meta

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;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results