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