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

方法一： select question_practice_detail.device_id,question_id,result from question_practice_detail left join user_profile on question_practice_detail.device_id=user_profile.device_id where university ='浙江大学';

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