1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

-- Popular questions requiring answers
-- Users coming from search engines

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

view current version

edited oct 18 16

created dec 21 13 Anton.