0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

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;

fork query

created dec 13 anonymous