0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

select
owneruserid as [User Link],
count(case when score> 0 then 1 end) positive_questions,
count(case when score<=0 then 1 end) nonpositive_questions,
1.0*count(case when score> 0 then 1 end)/(count(case when score> 0 then 1 end)+count(case when score<=0 then 1 end)) fraction_positive
from posts
where posttypeid=1 -- q
group by owneruserid
having count(case when posttypeid=1 then 1 end)>19
order by fraction_positive asc

fork query

edited mar 29 16

created mar 29 16 msh210