SELECT usp.device_id,
    qpd.question_id,
    qpd.result
FROM user_profile usp
JOIN  question_practice_detail qpd
    ON usp.device_id = qpd.device_id
WHERE university = '浙江大学'