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], 
  PostTypeID,
  ViewCount, 
  Score, 
  CAST(ViewCount as decimal(10,2))/Score as Ratio 
from Posts p 
where Score > 2 and ViewCount > '##MinimumNumberOfViews##'
order by Ratio asc

fork query

created aug 6 10 lkessler