Average quality of answers by users


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

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

-- Average quality of questions by users
-- Average votes of questions for users with at least MinQuestions questions

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

Enter Parameters

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