select device_id,question_id,result
from question_practice_detail
where device_id in
(select device_id from user_profile where university = '浙江大学');//一张表
select device_id,question_id,result
from question_practice_detail
where device_id in
(select device_id from user_profile where university = '浙江大学');//一张表