题解 | #浙江大学用户题目回答情况#

select user_profile.device_id,question_id,result
from question_practice_detail,user_profile
where question_practice_detail.device_id = user_profile.device_id
and user_profile.university='浙江大学'
order by question_id asc