select count(id), avg(upvotes), avg(downvotes) from users...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

select count(id), avg(upvotes), avg(downvotes) from users where reputation<200

------------- + Count + Avg Up + Avg Down +   Up   + Down 
-- All   users| 94897 |    4   |    0     | 395650 | 35461
--"Avid" users| 3250  |   94   |    9     | 308124 | 32221
--"New"  users|       |        |          |  87526 |  3240

Enter Parameters

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