Popular questions requiring answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Popular questions requiring answers
/*
Some SE questions stand high in search engine rankings.
This attracts traffic to SE, but such questions
don't get attention from the community. Also, users from
search engines typically don't vote. So you won't find
these questions on the front page.

This is the list of such questions ranked by the number of views
divided by the number of answers.

Additional fields:
- AnswerCount: number of answers
- AcceptedAnswerId: whether any answer was accepted
*/

select top 25
Id as [Post Link],
ViewCount / (AnswerCount + 1) as Views2Answers,
AnswerCount, AcceptedAnswerId
from Posts
where PostTypeId = 1
order by Views2Answers desc

Enter Parameters

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