Percentage of your total rep that came from accepted answers

3

Please login or register to vote for this query.

(click on this box to dismiss)

What percentage of your total rep comes from accepted answers (+15's).

Stack Overflow

Q&A for programmers

SELECT 
  Users.Id AS [User Link],
  Count(a.Id) AS [Number of accepts],
  COUNT(a.Id) * 15 AS [Rep from accepts],
  MAX(Users.Reputation) AS [Total rep],
  CAST((COUNT(a.Id) * 15) AS FLOAT) / CAST(MAX(Users.Reputation) AS FLOAT) * 100 AS [Percentage of total rep from accepts]
FROM
    Posts q
  INNER JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
  INNER JOIN
    Users ON Users.Id = a.OwnerUserId
WHERE 
    a.OwnerUserId = ##UserId##
GROUP BY Users.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached