Nice Questions without Nice Answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

All non-CW questions scored at least 10 with no non-CW answer that high.

Computational Science

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.

Select
  question.Id as [Post Link],
  question.Score,
  max(answer.Score) as "Top Answer",
  question.AnswerCount as "Answer Count",
  question.ViewCount as "View Count"
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 > 10 
group by
  question.Id,
  question.Score,
  question.Title,
  question.AnswerCount,
  question.ViewCount
having max(answer.score) < 10
order by question.score - max(answer.score) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results