select d.user_id, question_pass_rate, pass_rate, question_per_cnt from ( select user_id, count(question_id) / count(distinct question_id) question_per_cnt from ( select user_id, question_id, result_info, done_time from test.done_questions_record group by user_id, question_id, result_info, done_time ...