1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

fork query

edited jan 5 17

created jan 5 17 jon.doe7173