0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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 > 1000
GROUP BY
  u.DisplayName, u.Reputation
ORDER BY 
  [User RPC1k] DESC

view current version

edited apr 9 12

created apr 9 12 TomWij