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

答案1

SELECT q.device_id, question_id, result
FROM question_practice_detail q, user_profile u
WHERE q.device_id = u.device_id 
      AND u.university = '浙江大学';

答案2

SELECT q.device_id, question_id, result
FROM   question_practice_detail q
JOIN   user_profile u
ON     q.device_id = u.device_id 
WHERE  u.university = '浙江大学';

答案3

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