题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
SELECT `up`.`device_id`,`university`,COUNT(`question_id`) AS `question_cnt`,SUM(IF(`result`='right',1,0)) AS `right_question_cnt` FROM `user_profile` AS `up` LEFT JOIN `question_practice_detail` AS `qpd` ON `up`.`device_id`=`qpd`.`device_id` WHERE `university`='复旦大学' AND `date` LIKE '%08%' GROUP BY `up`.`device_id`;
