1 select difficult_level,sum(if(result='right',1,0))/count(q1.question_id) correct_rate 2 from user_profile u 3 inner join question_practice_detail q1 4 on u.device_id = q1.device_id 5 inner join question_detail q2 6 on q1.questio...