0

Please login or register to vote for this query.

(click on this box to dismiss)

Users ordered by the highest reputation per 1000 characters - it's like fuel efficiency for StackExchange. Use "DESC" in Order for Most Efficient, "ASC" for Least Efficient (those users who type a lot, but sadly, don't see a lot of gain from it) Filters for users above a minimal post count.

Q&A for computer enthusiasts and power users

SELECT TOP 2000
    Rank = Row_Number() OVER (ORDER BY Convert(int, Min(Convert(float, u.Reputation)) / sum(len(p.Body)) * 1000) ##Order##),
    [User Link] = p.OwnerUserId,
    Posts = Count(*),
    LengthAvg = avg(len(p.Body)),
    LengthMax = max(len(p.Body)),
    LengthStDev = Convert(int, stdev(len(p.Body))),
    LengthTotal = sum(len(p.Body)),
    Reputation = Min(u.Reputation),
    RepPer1000Char = Convert(int, Min(Convert(float, u.Reputation)) / sum(len(p.Body)) * 1000)
FROM Posts p
INNER JOIN Users u ON
    u.Id = p.OwnerUserId
WHERE
    p.PostTypeId = 2
    AND u.Reputation > 1
GROUP BY
    p.OwnerUserId
HAVING
    Count(*) >= ##MinimumPostCount##

fork query

created feb 9 11 Renesis