题解 | #浙江大学用户题目回答情况#
浙江大学用户题目回答情况
https://www.nowcoder.com/practice/55f3d94c3f4d47b69833b335867c06c1
select up.device_id, qpd.question_id, qpd.result from question_practice_detail as qpd inner join user_profile as up on qpd.device_id = up.device_id where up.university = "浙江大学" order by question_id
个人觉得这个写法更好点,因为https://www.runoob.com/w3cnote/sql-different-on-and-where.html
join有特殊性,所以最好join只用于相关联表具有相同值的字段的关联,而条件限制应当都写在where子句中。