0

Please login or register to vote for this query.

(click on this box to dismiss)

Ranked by ratio of minimum Views to Score

Q&A about the site for amateur radio enthusiasts

-- Best Questions 
-- Ranked by ratio of minimum Views to Score 

select top 500 
  Posts.Id as [Post Link],
  Users.Id as [User Link],
  CASE WHEN PostTypeId = 1 THEN 'Question' ELSE 'Answer' END As [Post Type],
  ViewCount, 
  Score, 
  ROUND(CAST(ViewCount as decimal(10,2))/Score, 3) as [Views per Score] 
FROM Tags
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON Posts.Id = PostTags.PostId
  JOIN Users ON Users.Id = Posts.OwnerUserId
where Score > 2 and ViewCount > '##MinimumNumberOfViews##' 
  and Tags.TagName = '##TagName##'
order by [Views per Score] asc

view current version

edited aug 6 10

created aug 6 10 lkessler