4

Please login or register to vote for this query.

(click on this box to dismiss)

All non-CW questions with at least 1000 views but no non-CW answer scored at least 10.

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- Popular Questions without Nice Answers
-- All non-CW questions with at least 1000 views but no non-CW answer scored at least 10.

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.ViewCount > 1000
group by
  question.Id,
  question.Score,
  question.Title,
  question.AnswerCount,
  question.ViewCount
having max(answer.score) < 10
order by question.ViewCount / case when max(answer.score) = 0 then 0.5 else max(answer.score) end desc

fork query

created aug 7 11 mattdm