Reputation per 1000 characters, for users > 2k.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  u.DisplayName AS [User Link],
  COUNT(p.Id) AS [Post Count],
  u.Reputation AS [User Reputation],
  u.Reputation * 1000 / SUM(LEN(p.Body)) AS [User RPC1k]
FROM
  Users U
JOIN
  Posts p ON p.OwnerUserId = u.Id
WHERE
  u.Reputation > 2000
GROUP BY
  u.DisplayName, u.Reputation
ORDER BY 
  [User RPC1k] DESC

Enter Parameters

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