题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
SELECT UP.device_id,UP.university,COUNT(QPD.question_id) AS question_cnt,SUM(IF(QPD.result='right',1,0)) AS right_question_cnt FROM user_profile AS UP INNER JOIN question_practice_detail AS QPD ON UP.device_id=QPD.device_id AND MONTH(QPD.date)=8 WHERE UP.university='复旦大学' GROUP BY UP.device_id;
投递拼多多集团-PDD等公司10个岗位 >
腾讯云智研发一面169人在聊
查看17道真题和解析
