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 
    CURRENT_TIMESTAMP AS QueryRunTime,
    ROUND(AVG(AnswerCount), 2) AS AverageAnswersPerQuestion
FROM (
    SELECT 
        Id, 
        (SELECT COUNT(*) 
         FROM Posts 
         WHERE PostTypeId = 2 AND ParentId = Posts.Id) AS AnswerCount
    FROM Posts
    WHERE PostTypeId = 1  -- Questions
) AS QuestionAnswers;

fork query

edited dec 11

created dec 11 anonymous