What is the median reputation level on SO?


Please login or register to vote for this query.

(click on this box to dismiss)

http://stackoverflow.com/a/7227860/578411 http://meta.stackoverflow.com/questions/296967/what-is-the-median-reputation-level-on-so

Stack Overflow

Q&A for professional and enthusiast programmers

-- http://stackoverflow.com/a/7227860/578411
select avg(reputation) median from
(select reputation, 
rnasc = row_number() over(order by reputation),
rndesc = row_number() over(order by reputation desc)
 from [users] 
) b
where rnasc between rndesc - 1 and rndesc + 1

Enter Parameters

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