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)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

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 to main site
loading Hold tight while we fetch your results