0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

SELECT 
    P.Id AS QuestionId,
    AVG(A.Score) AS AvgAnswerScore
FROM Posts P
JOIN Posts A ON P.Id = A.ParentId
WHERE P.PostTypeId = 1 AND P.AnswerCount > 5
GROUP BY P.Id;

view current version

edited dec 6

created dec 6 jon.doe46505