Total Reputation from Questions

2

Please login or register to vote for this query.

(click on this box to dismiss)

Ranks users by total reputation from questions (estimated by using the post score).

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    TOP 500
    Users.Id AS [User Link],
    Users.Reputation AS [Total Rep],
    SUM(Posts.Score)*5 + COUNT(Posts.AcceptedAnswerId)*2  AS [Question Rep]
FROM
    Users
  INNER JOIN
    Posts ON Posts.OwnerUserId = Users.Id
WHERE
   Posts.PostTypeId = 1 AND
   Posts.CommunityOwnedDate IS NULL
Group By
    Users.Reputation, Users.Id
Order By
    [Question Rep] DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results