1

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the number of characters entered to achieve each reputation point.

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT TOP 100
    u.Id AS [User Link],
    min(u.Reputation) as Reputation,
    sum(len(p.Body)) as TotalLength,
    count(*) as TotalPosts,
    avg(len(p.Body)) as AvgPostLength,
    (cast(sum(len(p.Body)) as float) / cast(min(u.Reputation) as float)) as PostLengthPerReputation
FROM
    Posts p
    INNER JOIN Users u ON u.Id = p.OwnerUserId
    AND u.Reputation > 1000
GROUP BY
    u.Id
ORDER BY
    PostLengthPerReputation DESC

fork query

edited apr 20 12 jadarnel27

created apr 20 12 jon.doe