1

Please login or register to vote for this query.

(click on this box to dismiss)

Users where reputation comes from asking good questions. This does not take into account downvotes on questions. So not 100% accurate though rather close. To avoid large result sets MinimumReputation and MinimumPercentage are provided. Young users with low rep are typically outliers and provide false results

Q&A for Ubuntu users and developers

-- Power Askers
-- Users where reputation comes from asking good questions.
-- This does not take into account downvotes on questions. So not 100% accurate though rather close.
-- To avoid large result sets MinimumReputation and MinimumPercentage are provided.
-- Young users with low rep are typically outliers and provide false results

SELECT
    Users.Id AS [User Link],
    Users.Reputation AS [Total Rep],
    ROUND(CAST((SUM(Posts.Score)*5) AS FLOAT) / Users.Reputation * 100, 1) AS [Question Rep %],
    COUNT(Posts.Id) AS [Questions Asked],
    ROUND(CAST((SUM(Posts.Score)*5) AS FLOAT), 1) as [Est. Rep from Qs]
FROM
    Users
  INNER JOIN
    Posts ON Posts.OwnerUserId = Users.Id
WHERE
   Users.Reputation > ##MinimumReputation## AND
   Posts.ParentId IS NULL AND
   Posts.CommunityOwnedDate IS NULL AND
   Posts.ClosedDate IS NULL
Group By
   Users.Id, Users.Reputation
HAVING
   ROUND(CAST((SUM(Posts.Score)*5) AS FLOAT) / Users.Reputation * 100, 1) > ##MinimumPercentage## AND
   COUNT(Posts.Id) > ##MinimumQuestions##
Order By
   [Question Rep %] DESC, [Questions Asked] DESC, [Total Rep] DESC, [Est. Rep from Qs]
   
   -- [Est. Rep from Qs] DESC, [Question Rep %] DESC, [Questions Asked] DESC, [Total Rep] DESC

fork query

created nov 29 10 Marco Ceppi