Avg score for answers

0

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

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached