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

# select device_id,question_id,result
# from question_practice_detail
# where device_id in(select device_id from user_profile where university ="浙江大学")
# order by question_id

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 up.university="浙江大学"
order by question_id