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

SELECT device_id, question_id, result
FROM question_practice_detail
WHERE device_id IN (SELECT device_id
FROM user_profile
WHERE university = '浙江大学');

方法2：

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 = '浙江大学';