4

Please login or register to vote for this query.

(click on this box to dismiss)

Average votes of answers for users with at least MinAnswers answers

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Average quality of answers by users
-- Average votes of answers for users with at least MinAnswers answers 

select top 2000 OwnerUserId [User Link], 
  Reputation,
  round(avg(Score + 0.0),2) as [Avg Score],
  count(*) as [Total Answers], 
  sum(case when Score < 0 then 1 else 0 end) as [Negative Scored Answers]
from Posts 
join Users u on u.Id = OwnerUserId 
where PostTypeId = 2
group by OwnerUserId, Reputation
having count(*) > ##MinAnswers##
order by [Avg Score] desc

fork query

edited may 13 13 Kaveh

created jul 13 10 sam.saffron