Users With Highest Reputation per Post

2

Please login or register to vote for this query.

(click on this box to dismiss)

Users with highest reputation per post

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

-- Your Posting Quality (Reputation per Posts)
-- Enter your user ID and find out how much rep you earn per post

SELECT
    Id AS [User Link],
    Reputation,
    counts.[# Posts],
    Reputation /
    counts.[# Posts] AS [Rep Per Post]
FROM Users
  CROSS APPLY (
    SELECT COUNT(*)
    FROM posts
    WHERE posts.OwnerUserId = Users.Id
  ) counts([# Posts])
WHERE Reputation > 200 and
      [# Posts] > ##MinPosts##
order by [Rep Per Post] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results