题解 | 验证刷题效果，输出题目真实通过率

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

稍稍有些感觉了 打卡第三天