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

select
    qpd.device_id,
    qpd.question_id,
    qpd.result
from
    question_practice_detail as qpd
    inner join user_profile as up on up.device_id = qpd.device_id
    and up.university = '浙江大学'
order by
    question_id

select
    device_id,
    question_id,
    result
from
    question_practice_detail
where
    device_id in (
        select
            device_id
        from
            user_profile
        where
            university = '浙江大学'
    )
order by
    question_id