Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear
select p.id as [Post Link], title, p.tags as Tags, p.ViewCount as "Views", p.score as "Score", p.AnswerCount as "Answers", DATEDIFF(day,p.CreationDate,getdate()) as "Age (days)", p.AcceptedAnswerId as "Answer Accepted?" from posts p where p.AnswerCount = 0 and DATEDIFF(day,p.CreationDate,getdate()) < ##maxage:int?200## and DATEDIFF(day,p.CreationDate,getdate()) > ##minage:int?0## order by p.score, p.viewcount desc;