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

fork query

created aug 6 10 lkessler