6

Please login or register to vote for this query.

(click on this box to dismiss)

list of users with less than 30 rep and 4 answers, sorted by the lowest question score average

Q&A for programming puzzle enthusiasts and code golfers

-- Shoot and run, newbies posting bad questions

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 Reputation < 30
group by OwnerUserId, Reputation
having count(*) < 5
order by [Avg Score] asc

fork query

created jul 13 10 sam.saffron