0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of poker

select top 1000  round(cast(ViewCount as float)/DATEDIFF(dd,CreationDate,getdate()),1) as  ViewsPerDay,      
       Id as [Post Link],
       ViewCount
  from Posts
 where PostTypeId = 1
       and    Score<100
 order by ViewsPerDay desc;

fork query

edited mar 20 14

created mar 20 14 anonymous