select t3.difficult_level, sum(if (t1.result='right',1,0 ))/count(t1.question_id)correct_rate from question_practice_detail as t1 left join user_profile as t2 on t1.device_id=t2.device_id left join question_detail as t3 on t1.question_id=t3.question_id where t2.university='浙江大学' group by difficult_level order by correct_rate asc

京公网安备 11010502036488号