The worst question askers

0

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

Chess Meta

Q&A about the site for serious players and enthusiasts of chess

-- 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 and u.LastAccessDate >= '1/7/2010'
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