Enter the minimum number of posts that a user must have, 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 (filter num posts) -- Enter the minimum number of posts that a user must have, and this will show the -- users who have the highest reputation per post in that group. SELECT Id AS [User Link], Reputation, Reputation * 1.0 / C.Cnt AS [Rep Per Post] FROM Users U, ( SELECT OwnerUserId, Cnt = Count(*) FROM posts GROUP BY OwnerUserID HAVING Count(*) >= ##MinNumberOfPosts## ) C WHERE U.Id = C.OwnerUserId ORDER BY [Rep Per Post] DESC