0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- 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 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)
GROUP BY a.OwnerUserId
ORDER BY [Unappreciated Answers] DESC

view current version

edited jan 4 14

created jan 4 14 jon.doe12549