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.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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