select qp.device_id,qp.question_id,qp.result 
from question_practice_detail as qp
inner join user_profile as up
where qp.device_id = up.device_id and up.university = '浙江大学'
order by qp.question_id