6

Please login or register to vote for this query.

(click on this box to dismiss)

Displays the top X users according to their accepted answer percentage multiplied by their total number of answers, within the group of users with more than Y answers in total. Looks only at open, non-CW questions and answers. This is an excellent metric of *answerer quality*; users that not only produce answers in quantity, but of consistently high quality as well.

Q&A for professional and enthusiast programmers

-- Users with Top Answer Effectiveness (accepted percentage times quantity)
-- Displays the top X users according to their accepted answer percentage
-- multiplied by their total number of answers.
-- Looks only at open, non-CW questions and answers.

SELECT TOP ##MaxUsers?200##
        a.OwnerUserId AS [User Link],
        Count(a.Id) AS [Total Answers],
        Sum(CASE q.AcceptedAnswerId WHEN a.Id THEN 1 ELSE 0 END) AS [Accepted Answers],  
        Round(Sum(CASE q.AcceptedAnswerId WHEN a.Id THEN 1 ELSE 0 END) * 100.0 / Count(a.Id), 2) AS [Percentage Accepted],
        Round(CAST(Sum(CASE q.AcceptedAnswerId WHEN a.Id THEN 1 ELSE 0 END) AS FLOAT) * (CAST(Sum(CASE q.AcceptedAnswerId WHEN a.Id THEN 1 ELSE 0 END) AS FLOAT) / Count(a.Id)), 2) AS Weighting
FROM    Posts AS a
   JOIN Posts AS q
     ON a.ParentId = q.Id
WHERE
        a.OwnerUserId is not NULL
    AND q.postTypeId = 1
    AND a.postTypeId = 2
GROUP BY
        a.OwnerUserId
ORDER BY
        Weighting DESC

fork query

edited jan 27 19 Martijn Pieters

created nov 17 11 tj