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.

Economics

Q&A for those who study, teach, research and apply economics and econometrics

-- 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 to meta site
loading Hold tight while we fetch your results