Avg score for answers


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Avg score for answers
select OwnerUserId as [User Link], avg(Score + 0.0), Reputation
from Posts
join Users u on u.Id = OwnerUserId
where CommunityOwnedDate is null and PostTypeId = 2 and Reputation > 5000
group by OwnerUserId, Reputation 
order by avg(Score + 0.0) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results