题解 | INNER JOIN ON

    qpd.device_id, qpd.question_id, qpd.result
from
    question_practice_detail as qpd
inner join
    user_profile as up
on
    up.device_id=qpd.device_id and up.university='浙江大学'
order by
    question_id
#     现在运营想要查看所有来自浙江大学的用户题目回答明细情况
#     在表中存在至少一个匹配时，INNER JOIN 关键字返回行。on里面的条件不符合就不会出来