0

Please login or register to vote for this query.

(click on this box to dismiss)

Users sorted by total number of views of their questions per day (with a slight softener to keep very new posts from skewing the results).

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Who Brings in the Crowds?
-- Users sorted by total number of views of their questions per day (with a slight softener to keep very new posts from skewing the results).

-- updated to use last database access (by a logged in user -- best we've got) instead of current_timestamp
SELECT TOP 1
  avg(q.ViewCount) AS [Avg Question Views]
FROM posts AS q
WHERE  
  q.PostTypeId=1

fork query

edited feb 24 12 anonymous

created aug 7 11 mattdm