# select device_id,question_id,result
# from question_practice_detail
# where device_id in 
# (select device_id from user_profile where university = '浙江大学')
# order by question_id;

select t1.device_id,question_id,result
from question_practice_detail t1
left join user_profile t2
on t1.device_id = t2.device_id
where university = '浙江大学';