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.

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 COUNT(*) AS QuestionsAnswered
 FROM Posts AS Answers
 JOIN Posts AS Questions
   ON Answers.ParentId = Questions.Id
 WHERE Answers.OwnerUserId = ##UserId##
 AND Questions.AcceptedAnswerId <> NULL

fork query

created mar 15 11 anonymous