Reputation averages

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT COUNT(Id) AS [Total Users],
       MIN(Reputation) AS [Minimum],
       MAX(Reputation) AS [Maximum],
       SUM(Reputation) / COUNT(Id) AS [Mean],
       (
           SELECT TOP 1 Reputation
           FROM Users
           GROUP BY Reputation
           ORDER BY COUNT(Reputation) DESC
       ) AS [Mode]
FROM Users

Enter Parameters

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