0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created mar 1 11 Stuart Pegg