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 and Answers
-- Ranked by ratio of minimum Views to Score 

select top 500 
  Id as [Post 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 Posts p 
where Score > 2 and ViewCount > '##MinimumNumberOfViews##' 
order by [Views per Score] asc

fork query

created aug 6 10 lkessler