题解 | #浙江大学用户题目回答情况#
浙江大学用户题目回答情况
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,
# 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
百度成长空间 585人发布