select a.device_id,a.university, count(question_id) as question_cnt, sum(if(result='right',1,0)) as right_question_cnt FROM user_profile a left JOIN question_practice_detail b on a.device_id = b.device_id and month(date)=8 where a.university = '复旦大学' group by device_id
点赞

相关推荐

把球:这个听过,你加了就会发现是字节的hr
点赞 评论 收藏
分享
牛客网
牛客企业服务