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

select UnluckyAnswer.Id, Question.Id, Question.AcceptedAnswerId
from Posts as UnluckyAnswer, Posts as Question
where 
	Question.Id = UnluckyAnswer.ParentId
	and Question.PostTypeId = 1
	and Question.AcceptedAnswerId is not NULL
	and Question.AcceptedAnswerId != UnluckyAnswer.Id
	and Question.AnswerCount >= 2
	and UnluckyAnswer.Score > 5
	and UnluckyAnswer.Score > (
	    select 0.67 * SUM(AllAnswers.score)
		from Posts as AllAnswers
		where Question.Id = AllAnswers.ParentId
		)

Enter Parameters

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