条件查询,device_id相等,university是浙江大学
select qpd.device_id,qpd.question_id,qpd.result
from question_practice_detail as qpd,user_profile as up
where qpd.device_id=up.device_id and up.university='浙江大学';