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