看了一下如下答案,醍醐灌顶~红红火火恍恍惚惚 SELECT university, count(*)/count(DISTINCT q.device_id) avg_answer_cnt FROM question_practice_detail q LEFT JOIN user_profile u ON u.device_id=q.device_id GROUP by university
点赞
牛客网
牛客企业服务