select user_profile.device_id, question_practice_detail.question_id, question_practice_detail.result from user_profile left join question_practice_detail on user_profile.device_id=question_practice_detail.device_id where user_profile.university='浙江大学' order by question_practice_detail.question_id as...