Popular with everyone but the OP

0

Please login or register to vote for this query.

(click on this box to dismiss)

Answers that earn >67% of the total score for a question's answers, but lost out to another answer for acceptance.

Engineering

Q&A for professionals and students of engineering

-- First all questions with two answers, and their total score.
select max(Question.Id), max(Question.AcceptedAnswerId), sum(AllAnswers.score)
from Posts as Question, Posts as AllAnswers
where Question.Id = AllAnswers.ParentId
      and Question.AcceptedAnswerId is not NULL
	  and Question.AnswerCount >= 2

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results