Best Questions and Answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ranked by ratio of minimum Views to Score

Amateur Radio Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results