All non-CW questions with at least 1000 views but no non-CW answer scored at least 10.
Q&A about the site for gardeners and landscapers
-- Popular Questions without Nice Answers
-- All non-CW questions with at least 1000 views but no non-CW answer scored at least 10.
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.ViewCount > 1000
having max(answer.score) < 10
order by question.ViewCount / case when max(answer.score) = 0 then 0.5 else max(answer.score) end desc