SELECT difficult_level, SUM(IF(result='right',1,0)) / COUNT(*) correct_rate FROM( SELECT up.device_id, qpd.question_id, qpd.result, qd.difficult_level FROM user_profile up JOIN question_practice_detail qpd ON up.device_...