Your Posting Quality (Reputation per Posts)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter your user ID and find out how much rep you earn per post

Stack Overflow

Q&A for professional and enthusiast programmers

-- 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 > 1000
order by Reputation / counts.[# Posts]

Enter Parameters

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