Users with many zero-score, not accepted, not commented upon, uncontested 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

-- unappreciated = not accepted, zero score, no comments
-- uncontested = the only answer posted to the question

select top 500 
   a.OwnerUserId as [User Link],
   sum(case when a.Score=0 and a.CommentCount is null then 1 else 0 end) as [Unappreciated Uncontested Answers], 
   count(a.Id) as [Total Uncontested 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 AND q.AnswerCount = 1 AND q.AcceptedAnswerId IS NULL)
GROUP BY a.OwnerUserId
ORDER BY [Unappreciated Uncontested Answers] DESC

Enter Parameters

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