The worst question askers

9

Please login or register to vote for this query.

(click on this box to dismiss)

All people who asked more than 20 questions ordered by avg score

Genealogy and Family History Meta

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

-- The worst question askers
-- All people who asked more than 20 questions ordered by avg score

select top 2000 OwnerUserId [User Link], 
  Reputation,
  count(*) [Total Questions], 
  avg(Score + 0.0) [Avg Score],
  sum(case when Score < 0 then 1 else 0 end) [Negative Scored Questions]
from Posts 
join Users u on u.Id = OwnerUserId 
where ParentId is null
group by OwnerUserId, Reputation
having count(*) > 20
order by [Avg Score] asc

Enter Parameters

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