-- 本题涉及多表连接
 -- 1.将question_practice_detail表与user_profile连接查询，条件为共有列device_id
 -- 2.过滤出university = '浙江大学'的记录即可
select
    qpd.device_id,
    question_id,
    result
from
    question_practice_detail qpd,
    user_profile up
where
    qpd.device_id = up.device_id
    and university = '浙江大学';