0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for power users of web applications

SELECT 
    u.Id, 
    AVG(p.Score) AS AnswerQualityScore
FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 2
GROUP BY u.Id
HAVING COUNT(p.Id) >= 1
ORDER BY AnswerQualityScore DESC;

fork query

edited dec 12

created dec 12 anonymous