select cast(count(v.Id) as float) / p.ViewCount as value ...

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 cast(count(v.Id) as float) / p.ViewCount as value
    from Votes v, Posts p
    where v.VoteTypeId in (2, 3)
        and p.Id = v.PostId
        and p.posttypeid = 1
    group by p.ViewCount, p.id

Enter Parameters

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