0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT u.Id as [User Link],
       AVG(LEN(p.Body)) AS AverageLength,
       AVG(p.Score) AS AverageScore,
       COUNT(p.Id) AS NumberOfAnswers
FROM Posts AS p INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 2
GROUP BY u.DisplayName, u.Id
HAVING COUNT(p.Id) > ##MinimumAnswers?2## AND 
       AVG(p.Score) > ##MinimumScore?2##
ORDER BY u.DisplayName ASC

fork query

edited jul 24 14 jon.doe10086

created jul 24 14 Chris White