select university, difficult_level, count(qpd.question_id) / count(distinct qpd.device_id) as avg_answer_cnt from question_practice_detail as qpd inner join user_profile as up on up.device_id=qpd.device_id and up.university="山东大学" inner join question_detail as qd on qd.question_id=qpd.question_id group by difficult_level;
点赞

相关推荐

在看数据的傻狍子很忙碌:学生思维好重,而心很急,自己想想真的能直接做有难度的东西吗?任何错误都是需要人担责的,你实习生可以跑路,你的同事领导呢
点赞 评论 收藏
分享
求面试求offer啊啊啊啊:1600一个月?
点赞 评论 收藏
分享
牛客网
牛客企业服务