select user_id, count(distinct if (result_info = 1, question_id, null)) / count(distinct question_id) as question_pass_rate, sum(result_info) / count(result_info) as pass_rate, count(question_id) / count(distinct question_id) as question_per_cnt from done_questions_record group by user_id having question_pass_rate > 0.6;