0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter the minimum rep to consider, and this will show the users who have the highest reputation per post in that group.

Q&A for professional and enthusiast programmers

-- Users With the Highest Quality Posts
-- Enter the minimum rep to consider, and this will show the
-- users who have the highest reputation per post in that group.
DECLARE @MinPosts int = ##MinNumberOfPosts##
SELECT
    Id AS [User Link],
    Reputation,
    (SELECT COUNT(*)
    FROM posts
    WHERE posts.OwnerUserId = Users.Id
    ) AS [# Posts],
    Reputation /
    (SELECT COUNT(*)
    FROM posts
    WHERE posts.OwnerUserId = Users.Id
    ) AS [Rep Per Post]
FROM Users
WHERE     (SELECT COUNT(*)
    FROM posts
    WHERE posts.OwnerUserId = Users.Id
    ) > @MinPosts
ORDER BY [Rep Per Post] DESC

fork query

created sep 5 10 Peter Ajtai