select difficult_level,sum(if(result='right',1,0))/count(result) correct_rate
from question_practice_detail a,user_profile b,question_detail c
where a.device_id=b.device_id and a.question_id=c.question_id
and university='浙江大学'
group by difficult_level
order by correct_rate