Or 'concise', depending how you look at it
Q&A about the site for committed Christians, experts in Christianity and those interested in learning more
-- Most abrupt users -- Or 'concise', depending how you look at it SELECT TOP 100 U.DisplayName, P.AvgPost, P.MinPost, C.AvgComment, C.MinComment FROM (SELECT OwnerUserId, Avg(Len(Body)) AvgPost, Min(Len(Body)) MinPost FROM Posts GROUP BY OwnerUserId) P INNER JOIN (SELECT UserId, Avg(Len(Text)) AvgComment, Min(Len(Text)) MinComment FROM Comments GROUP BY UserId) C ON P.OwnerUserId = C.UserId INNER JOIN Users U ON C.UserId = U.Id WHERE MinPost < 5 OR MinComment < 4 ORDER BY P.AvgPost + C.AvgComment