Questions with all answers having at least given score

1

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT question.Id as [Post Link],
  question.Score,
  question.AnswerCount,
  min(answer.Score) as "Lowest answer score"
FROM Posts as question, Posts as answer
WHERE question.PostTypeId = 1
  AND  answer.PostTypeId=2 
  AND answer.ParentId = question.Id 
  AND (question.AnswerCount>=##NumberOfAnswers?5##)
GROUP BY 
  question.Id,
  question.Score,
  question.AnswerCount
HAVING min(answer.score) >= ##MinScore?10##
ORDER BY question.Score DESC

Enter Parameters

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