select
difficult_level
,count(case when result='right' then 1 end)/count(device_id) as correct_rate
from  question_practice_detail
left join user_profile
using(device_id)
left join  question_detail
using(question_id)
where university='浙江大学'
group by 1
order by 2