Average quality of answers by users

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

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results