select q.device_id, q.question_id,q.result 
from question_practice_detail q
join user_profile u
on q.device_id = u.device_id
where u.university ='浙江大学'

不难