Accepted answer percentage of questions with accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Calculates the percentage of how many of a user's answers are accepted relative to all questions answered by the user that have an accepted answer. This ignores questions without an accepted answer, since they are usually either abandoned or just can't be answered.

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

-- Accepted answer percentage of questions with accepted answers
-- Calculates the percentage of how many of a user's answers are 
-- accepted relative to all questions answered by the user that have 
-- an accepted answer. This ignores questions without an accepted answer, 
-- since they are usually either abandoned or just can't be answered.

SELECT
(
 SELECT COUNT(*) AS QuestionsAnswered
 FROM Posts AS Answers
 JOIN Posts AS Questions
   ON Answers.ParentId = Questions.Id
 WHERE Answers.OwnerUserId = ##UserId##
 AND Questions.AcceptedAnswerId <> NULL
)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results