Q&A for cartographers, geographers and GIS professionals
-- 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