0

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 about the site for movie and tv enthusiasts

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

fork query

edited jun 9 12 jon.doe8101

created apr 20 12 jadarnel27