select qd.difficult_level, sum(if(qpd.result='right',1,0)) / count(qpd.result) as correct_rate from question_practice_detail as qpd join user_profile as u on u.device_id = qpd.device_id and u.uni...