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

select us.device_id,que.question_id,que.result 
from question_practice_detail as que
inner join user_profile as us
on que.device_id = us.device_id 
and university = '浙江大学';