Users with many zero-score uncommented, not accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select top 500 
   a.OwnerUserId as [User Link],
   sum(case when a.Score=0 and isnull(q.AcceptedAnswerId,0) != a.Id  and a.CommentCount is null then 1 else 0 end) as [Unappreciated Answers], 
   count(a.Id) as [Total Answers], 
   100*cast(sum(case when a.Score=0 and a.CommentCount is null then 1 else 0 end) as float)/count(a.Id)  as [Percentage Unappreciated]
FROM Posts a
INNER JOIN Posts q 
ON (q.Id = a.ParentId)
GROUP BY a.OwnerUserId
ORDER BY [Unappreciated Answers] DESC

Enter Parameters

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