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

# with a as (select device_id from user_profile where university='浙江大学')
# select device_id, question_id, result from question_practice_detail
# where device_id in 
# (select * from a);


with a as (select device_id from user_profile where university='浙江大学')
select a.device_id, question_id, result 
from question_practice_detail qp
inner join a on qp.device_id=a.device_id;



# select device_id, question_id, result from question_practice_detail
# where device_id in 
# (select device_id from user_profile where university='浙江大学');



# select u.device_id, question_id, result 
# from question_practice_detail q inner join 
# (select * from user_profile where university='浙江大学') u
# on q.device_id=u.device_id ;


# select u.device_id, question_id, result 
# from question_practice_detail q inner join user_profile u
# on q.device_id=u.device_id 
# where university='浙江大学';