题解 | #浙江大学用户题目回答情况#
浙江大学用户题目回答情况
https://www.nowcoder.com/practice/55f3d94c3f4d47b69833b335867c06c1
SELECT qpd.device_id,
qpd.question_id,
qpd.result
-- 写别名要加AS
FROM question_practice_detail AS qpd
INNER JOIN user_profile AS up
-- 筛选条件写在ON后面
ON qpd.device_id = up.device_id AND up.university = "浙江大学";
京东HR面46人在聊
投递斑马网络等公司10个岗位 >