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
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务