题解 | 浙江大学用户题目回答情况

# 方法一
# 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 u.device_id, q.question_id, q.result
# from question_practice_detail as q, user_profile as u
# where 
#   university = '浙江大学' and q.device_id = u.device_id
# order by 
#     q.question_id ASC;


# 方法三
# select u.device_id, q.question_id, q.result
# from question_practice_detail q join user_profile u on q.device_id = u.device_id and u.university = '浙江大学'
# order by q.question_id ASC;


# 方法四
# select u.device_id, q.question_id, q.result
# from question_practice_detail q join user_profile u on q.device_id = u.device_id
# where u.university = '浙江大学'
# order by q.question_id ASC;