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',
        AVG(Reputation) AS 'Average',
        SUM(Reputation) / COUNT(*) AS 'a',
        STDEV(Reputation) AS 'Std. Deviation'
        FROM Users
)
SELECT * FROM p

fork query

created sep 23 10 anonymous