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.

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- 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)

fork query

created jul 14 10 donkirkby