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

SELECT Q.device_id, Q.question_id, Q.result
FROM user_profile AS U inner join question_practice_detail AS Q   
    WHERE U.university = '浙江大学'
    AND Q.device_id = U.device_id;