# 查看所有来自浙江大学的用户题目回答明细情况
select 
    device_id,
    question_id,
    result
from question_practice_detail
where device_id in (
    select device_id from user_profile where university = '浙江大学'
)
;