select
    question_practice_detail.device_id as device_id,
    question_practice_detail.question_id as question_id,
    question_practice_detail.result as result
from question_practice_detail,user_profile
where question_practice_detail.device_id=user_profile.device_id
and user_profile.university='浙江大学';