Average reputation of users given by Stack Overflow's Total Reputation boundaries

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT
  1,
  avg(reputation)                     average,
  ((avg(reputation) - 1) / 1.0) * 100 percentage
FROM users u1
WHERE u1.reputation >= 1
UNION SELECT
        200,
        avg(u200.reputation)                         average,
        ((avg(u200.reputation) - 1) / 200.0) * 100 percentage
        FROM users u200

Enter Parameters

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