Questions with highest upvotes to views ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 50 cast(count(v.Id) as float) / p.ViewCount as ratio, p.id as [Post Link]
    from Votes v, Posts p
    where v.VoteTypeId = 2
        and p.Id = v.PostId
        and p.posttypeid = 1
        --and p.Tags like '%python%'
        and p.ViewCount > 1000
    group by p.ViewCount, p.id
    order by ratio desc

Enter Parameters

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