Question reps

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 500
    Users.Id AS [User Link],
    Users.Reputation AS [Total Rep],
    SUM(Posts.Score)*5 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