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;

京公网安备 11010502036488号