Zero scored question ratio by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select count(*) N, 
       TagName, 
       1 - count(case when Score = 0 then 1 end)*1.0/count(*) voting_ratio
from Posts p
     join PostTags on p.Id = PostId
     join Tags t on t.Id = TagId
where Score >= 0
group by TagName
having count(*) > 75000
order by count(case when Score = 0 then 1 end)*1.0/count(*)

Enter Parameters

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