Level of Effort

0

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 > 20000
GROUP BY
    u.Id
ORDER BY
    PostLengthPerReputation DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results