Wilson confidence rating for posts of a user

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://stackapps.com/questions/8555/request-for-user-script-to-calculate-wilson-confidence-ratings-for-posts

Woodworking

Q&A for professional and amateur woodworkers

select p.id
     , p.owneruserid
     , sum(case when v.votetypeid = 2 then 1 else 0 end) upvotes
     , sum(case when v.votetypeid = 3 then 1 else 0 end) downvotes
from posts p
inner join votes v on v.postid = p.id
where v.votetypeid in (2,3)
and p.owneruserid = 2157772
group by p.id
       , p.owneruserid

Enter Parameters

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