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

select q.device_id, question_id, result 
from question_practice_detail as q, user_profile as u 
where q.device_id = u.device_id and university = '浙江大学';
两个表中有相同的字段，数据库不知道如何区分，所以前面要加上表名