list of users with less than 30 rep and 4 answers, sorted by the lowest question score average
Q&A for Drupal developers and administrators
-- 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