Users sorted by average score.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Votes per answer (non-CW, with at least 100 answers to their credit)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

-- Users sorted by average score.
-- Votes per answer (non-CW, with at least 50 answers to their credit)

select top 100 u.id as [User Link], u.reputation as 'Rep', count(a.id) as 'Answers', 
sum(a.score) as 'Total Score',
cast (sum(a.score) as float) / cast(count(a.id) as float) as  'Average'
from posts a, users u
where a.owneruserid = u.id
and a.posttypeid = 2 
and a.communityowneddate is null 
group by u.id, u.reputation
having count(a.id) > 50
order by cast (sum(a.score) as float) / cast(count(a.id) as float) desc

Enter Parameters

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