The true unsung heros


Please login or register to vote for this query.

(click on this box to dismiss)

List of users with more than 10 zero score answers, ordered by ratio of zero to non zero score

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

-- Enter Query Title
-- Enter Query Description

select X.*, u.Reputation from (
  select a.OwnerUserId [User Link], 
  sum(case when a.Score = 0 then 0 else 1 end) as [Non Zero Score Answers],  
  sum(case when a.Score = 0 then 1 else 0 end) as [Zero Score Answers]
from Posts q
join Posts a on a.Id = q.AcceptedAnswerId 
where a.CommunityOwnedDate is null and a.OwnerUserId is not null
 and a.OwnerUserId <> isnull(q.OwnerUserId,-1)
group by a.OwnerUserId
having sum(case when a.Score = 0 then 1 else 0 end) > 10
) as X 
join Users u on u.Id = [User Link]
order by ([Zero Score Answers]+ 0.0) / ([Zero Score Answers]+ [Non Zero Score Answers]+ 0.0) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results