How unsung are you?

4

Please login or register to vote for this query.

(click on this box to dismiss)

Count your zero score accepted answers and total accepted answers. Note that some other similar queries don't exclude answers to your own questions. I'm pretty sure the badge excludes them.

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

-- How unsung are you?
-- Count your zero score accepted answers and total accepted answers.
-- Note that some other similar queries don't exclude answers to your own 
-- questions. I'm pretty sure the badge excludes them.

select count(*) as [Total Answers],  
       sum(case when a.Score = 0 then 1 else 0 end) as [Zero Score Answers],
       sum(case when a.Score = 0 then 1 else 0 end) * 100.0 / 
       count(*) as [Percent Zeros]
from Posts q
join Posts a on a.Id = q.AcceptedAnswerId 
where a.OwnerUserId = ##UserId##
 and a.CommunityOwnedDate is null 
 and (a.OwnerUserId <> q.OwnerUserId or q.OwnerUserId is null)

Enter Parameters

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