0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Q&A for Ubuntu users and developers

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

select top 200 OwnerUserId [User Link], 
  Reputation,
  count(*) [Total Questions], 
  avg(Score + 0.0) [Avg Score],
  100.0 * sum(case when Score > 0 then 1 else 0 end) / count(*) [% Questions with positive Score],
  max(Posts.CreationDate) [Newest question]
from Posts 
join Users u on u.Id = OwnerUserId 
where ParentId is null and u.Id != -1
group by OwnerUserId, Reputation
having count(*) > 30
order by [Avg Score] asc

fork query

edited jun 3 23 Marcus.M252ller

created jul 13 10 sam.saffron