Popular with everyone but the OP


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.


Q&A for professionals and students of engineering

select top 100 UnluckyAnswer.OwnerUserId as [User Link], Question.Id as [Post Link], UnluckyAnswer.Score as [Ignored Score]
from Posts as UnluckyAnswer, Posts as Question
	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
order by UnluckyAnswer.Score desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results