Views per Day for the Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

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

/*This query returns the number of views per day for your questions*/
  
DECLARE @UserId int = ##UserId##

select ViewCount,
       round(cast(ViewCount as float)/DATEDIFF(dd,CreationDate,getdate()),1) ViewsPerDay,
       Id as [Post Link]
  from Posts
 where PostTypeId = 1
   and OwnerUserId = @UserId
 order by Id;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results