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

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