average votes per view for questions

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 avg(value)
from (
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
) t

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results