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

select
    b.device_id,
    b.question_id,
    b.result
from
    user_profile a
    join question_practice_detail b on a.device_id = b.device_id
    and a.university = '浙江大学'