SELECT COUNT(Id) AS [Total Users], MIN(Reputation) AS [Mi...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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