Answers with 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, based on the view count of their respective parent questions

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

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

Enter Parameters

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