3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Highest view rate questions in a particular tag (non-Community Wiki).
-- Highest hitrate non-CW questions, (presumably) what questions are
-- viewed the most per time unit from Google searches.

SELECT TOP 100
    p.Id as [Post Link],
    p.Id as [Post ID],
    Score as [Votes],
    ViewCount as [Views],
    DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) as Age,
    p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) as [View rate]
FROM Posts p
WHERE p.ViewCount > 28 AND --On Stack Overflow there are 100 non-CW post with more than about 28000.
      p.CommunityOwnedDate is null AND -- Field CommunityOwnedDate is absent for non-CW posts.
      p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) > 5 AND
      p.Tags LIKE '%docker%'
      -- ViewCount / age >
ORDER BY [View Rate] DESC

view current version

edited mar 10 17

created jan 31 14 Peter Mortensen (resurrected)