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

SELECT
    qpd.device_id device_id,
    qpd.question_id question_id,
    qpd.result result
FROM
    question_practice_detail qpd
INNER JOIN user_profile up ON 
    qpd.device_id = up.device_id AND
    up.university = '浙江大学'
ORDER BY
    question_id
;