0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows various statistics about users' reputation scores

Q&A for speakers of other languages learning English

-- Aggregate User Reputation Statistics
-- Shows various statistics about users' reputation scores

WITH p AS
(
    SELECT
        'All Users' AS ' ',
        COUNT(*) AS Count,
        MAX(Reputation) AS Maximum,
        AVG(Reputation) AS Average,
        (SELECT TOP 1 q.Reputation FROM (SELECT TOP 50 PERCENT Reputation FROM Users ORDER BY Reputation ASC) q) AS Median,
        STDEV(Reputation) AS 'Std. Deviation'
        FROM Users
)
SELECT * FROM p

fork query

created sep 23 10 anonymous