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

SELECT A.device_id,A.question_id,A.result FROM 
(SELECT device_id,question_id,result FROM question_practice_detail) A JOIN
(SELECT device_id FROM user_profile WHERE university='浙江大学') B ON
A.device_id=B.device_id ORDER BY A.question_id