Mean Score Per User

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select u.Id as uid, avg(q.Score) as mean_score from Users u
inner join Posts a on a.OwnerUserId = u.Id
inner join Posts q on a.ParentId = q.Id 
group by u.Id
order by avg(q.Score) desc

Enter Parameters

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