0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT 
    Questions.ID AS QuestionID, 
    AVG(Answers.Score) AS AverageAnswerScore
From 
    Posts AS Questions
JOIN 
    Posts AS Answers ON Questions.ID = Answers.ParentId 
WHERE 
    Questions.PostTypeID = 1 
    AND 
    Answers.PostTypeID = 2 
GROUP BY 
    Questions.ID
HAVING 
    COUNT(Answers.ID) > 5;

view current version

edited dec 11

created dec 11 jon.doe46557