SELECT tmp1.difficult_level, IFNULL(( right_num / num ),0) AS correct_rate FROM ( SELECT det.difficult_level, count( 1 ) AS num FROM `user_profile` pro LEFT JOIN question_practice_detail pra ON pro.device_id = pra.device_id LEFT JOIN question_detail det ON pra.question_id = det.question_id...