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).

Q&A for people studying math at any level and professionals in related fields

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

fork query

edited jul 23 13 jon.doe11527

created nov 29 10 moberley