All non-CW questions scored at least 10 with no non-CW answer that high.
Q&A for scientists using computers to solve scientific problems
-- Nice Questions without Nice Answers
-- All non-CW questions scored at least 10 with no non-CW answer that high.
question.Id as [Post Link],
max(answer.Score) as "Top Answer",
question.AnswerCount as "Answer Count",
question.ViewCount as "View Count"
Posts as question,
Posts as answer
answer.CommunityOwnedDate is null and
question.CommunityOwnedDate is null and
answer.ParentId = question.Id and
question.Score > 10
having max(answer.score) < 10
order by question.score - max(answer.score) desc