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

select q.device_id, q.question_id, q.result
from user_profile u
         left join question_practice_detail q on u.device_id = q.device_id
where u.university = '浙江大学' order by q.question_id;