#思路:三表连接,筛选浙大学生,用难度分组聚合再计算即可。注意,未答题的浙大学生不显示,所以要用第二张表左联第一张表。 select difficult_level, count(if(result='right',1,null))/count(result) a from question_practice_detail left join user_profile using(device_id) left join question_detail using(question_id) where university='浙江大学' group by difficult_level order by a