题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
select device_id, university, count(1) as question_cnt, sum(result = 'right') as right_question_cnt from question_practice_detail inner join user_profile using(device_id) where university = '复旦大学' and date_format(date,'%m') = '08' group by device_id
投递国家开发银行等公司10个岗位 >