0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT 
    P.OwnerUserId AS UserId,
    AVG(P.Score) AS AvgAnswerQuality
FROM Posts P
WHERE P.PostTypeId = 2
GROUP BY P.OwnerUserId
HAVING COUNT(*) > 0
ORDER BY AvgAnswerQuality DESC;

view current version

edited dec 7

created dec 7 jon.doe46505