0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

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 desc, p.viewcount desc;

fork query

edited jun 23 18 anonymous

created may 19 16 karann