SQL22题解 |#统计每个学校的答过题的用户的平均答题数#

SELECT university,
    count(question_id)/count(distinct Q.device_id) AS avg_answer_cnt
    FROM question_practice_detail   AS Q
    INNER JOIN user_profile         AS U
    ON Q.device_id = U.device_id
    GROUP BY university;