题解 | #浙江大学用户题目回答情况#
浙江大学用户题目回答情况
https://www.nowcoder.com/practice/55f3d94c3f4d47b69833b335867c06c1?tpId=199&tags=&title=&difficulty=0&judgeStatus=0&rp=0&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D199
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 university = '浙江大学'
order by question_id