0

Please login or register to vote for this query.

(click on this box to dismiss)

the top 50, in descending order

Q&A about the site for enthusiasts and scholars of mythology and folklore

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

fork query

created nov 8 11 burpenator