题解 | 统计每个用户的平均刷题数
统计每个用户的平均刷题数
https://www.nowcoder.com/practice/f4714f7529404679b7f8909c96299ac4
select B.university,C.difficult_level, count(B.answer_cnt)/count(distinct A.device_id) from question_practice_detail A Inner join user_profile B on A.device_id = B.device_id Inner join question_detail C on A.question_id = C.question_id where B.university = "山东大学" group by difficult_level
查看14道真题和解析
投递北京经纬恒润科技股份有限公司等公司10个岗位
