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 UnluckyAnswer.OwnerUserId as [Unloved User Link], Question.Id as [Post Link], Question.AcceptedAnswerId
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

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results