题解 | #浙江大学用户题目回答情况#

select qpd.device_id, qpd.question_id, qpd.result
from question_practice_detail as qpd
inner join user_profile as up
on up.device_id = qpd.device_id and university = "浙江大学"
order by question_id