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

SELECT t1.device_id,t2.question_id,t2.result
FROM user_profile AS t1
LEFT JOIN question_practice_detail AS t2
ON  t1.device_id=t2.device_id
WHERE t1.university="浙江大学"
ORDER BY t2.question_id;