select question_practice_detail.device_id, question_practice_detail.question_id, question_practice_detail.result 
FROM question_practice_detail inner join user_profile
ON question_practice_detail.device_id=user_profile.device_id 
and user_profile.university='浙江大学'

主要考察...inner join... on.....的用法。需要加强练习。多记住。