题解 | 统计复旦用户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
where up.university="复旦大学" and qpd.date like "2021-08%"
group by qpd.device_id
查看19道真题和解析