The true unsung heros

14

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

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

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

Options:
Switch to main site
loading Hold tight while we fetch your results