Questions with the highest Score to View Count ratios

0

Please login or register to vote for this query.

(click on this box to dismiss)

the top 50, in descending order

Stack Overflow

Q&A for professional and enthusiast programmers

-- Questions with the highest Score to View Count ratios
-- the top 50, in descending order

select top 50
    id as [Post Link],
    (cast(score as decimal)/cast(viewcount as decimal)) as 'Score:Viewcount',
    Score,
    ViewCount,
    CreationDate
from posts
where viewcount > 0
and posttypeid = 1
order by 'Score:Viewcount' desc

Enter Parameters

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