1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for user experience researchers and experts

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

select top 25
Id as [Post Link],
datediff(d, CreationDate, getdate()) as AgeDays,
Score, ViewCount, AnswerCount,
ViewCount / (AnswerCount + 1) as Views2Answers
--( ViewCount / AgeDays ) as ViewsPerDay
from Posts
where
  PostTypeId = 1 and
--  AcceptedAnswerId is null and
  ClosedDate is null and
  CommunityOwnedDate is null
--  and CreationDate > '2017-02-01'
  and AnswerCount = 0
  and datediff(d, CreationDate, getdate()) < 700
order by ViewCount desc

fork query

edited mar 7 17

created dec 21 13 Anton.