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