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

Q&A for people interested in the history and origins of science and mathematics

SELECT 
  Users.Id AS [User Link],
  Count(a.Id) AS [NumAcceptedAnswers],
  COUNT(a.Id) * 15 AS [RepFromAcceptedAnswers],
  MAX(Users.Reputation) AS [Total Rep],
  CAST((COUNT(a.Id) * 15) AS FLOAT) / CAST(MAX(Users.Reputation) AS FLOAT) AS [PercentRepFromAccepts]
FROM
    Posts q
  INNER JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
  INNER JOIN
    Users ON Users.Id = a.OwnerUserId
WHERE 
    a.OwnerUserId = 861565
GROUP BY Users.Id

view current version

edited apr 20 12

created apr 20 12 jadarnel27