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

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

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

还没搞明白这玩意儿叫什么，语法挺像普通高级语言的也就