题解 | 浙江大学用户题目回答情况
浙江大学用户题目回答情况
https://www.nowcoder.com/practice/55f3d94c3f4d47b69833b335867c06c1
select device_id,question_id,result
from question_practice_detail
where device_id in (
select device_id
from user_profile
where university='浙江大学'
)
order by question_id;
# 或
select qpd.device_id,question_id,result
from question_practice_detail qpd join user_profile up on qpd.device_id=up.device_id and up.university='浙江大学'
order by question_id;
查看26道真题和解析