All non-CW questions scored less than 25 with answers scored over that.
Q&A for professional, enthusiast and amateur photographers
-- Lesser Questions with Good Answers
-- All non-CW questions scored less than 25 with answers scored over that.
question.Id as [Post Link],
max(answer.Score) as "Top Answer Score",
question.AnswerCount as "Answers",
question.ViewCount as "Views"
Posts as question,
Posts as answer
answer.CommunityOwnedDate is null and
question.CommunityOwnedDate is null and
answer.ParentId = question.Id and
question.Score < 25
having max(answer.score) > 25
order by max(answer.score) - question.score desc