题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
select device_id,university,sum(nquestion)question_cnt,sum(nright_question)right_question_cnt from (select device_id,university,if(question_id is not null,1,0) nquestion,if(result='right',1,0) nright_question from(select u.device_id,university,question_id,result,date from user_profile u left join (select * from question_practice_detail where month(date)=8 ) q on u.device_id =q.device_id where university='复旦大学')aa)bb group by university,device_id
投递长鑫存储等公司10个岗位
