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

select user_id, COUNT(DISTINCT CASE WHEN result_info = 1 THEN question_id ELSE NULL END) / count(distinct question_id) question_pass_rate, sum(result_info)/count(user_id) as pass_rate, count(*)/count(distinct question_id) as question_per_cnt
from done_questions_record
group by user_id
having SUM(case when result_info = 1 THEN 1 ELSE 0 END) / count(distinct question_id)>0.6