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, 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