Lesser Questions with Good Answers

Please login or register to vote for this query.

(click on this box to dismiss)

All non-CW questions scored less than 25 with answers scored over that.

Welcome to Q&A for professional photographers, photo editors, and serious enthusiasts

-- Lesser Questions with Good Answers
-- All non-CW questions scored less than 25 with answers scored over that.

Select
  question.Id as [Post Link],
  question.Score,
  max(answer.Score) as "Top Answer Score",
  question.AnswerCount as "Answers",
  question.ViewCount as "Views"
from
  Posts as question,
  Posts as answer
where  
  answer.CommunityOwnedDate is null and
  question.CommunityOwnedDate is null and
  answer.PostTypeId=2 and
  answer.ParentId = question.Id and
  question.Score < 25
group by
  question.Id,
  question.Score,
  question.Title,
  question.AnswerCount,
  question.ViewCount
having max(answer.score) > 25
order by max(answer.score) - question.score  desc

created may 12 11