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

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(done_time) / count(distinct  question_id) as question_per_cnt
from
    done_questions_record  
    group by user_id
    having  question_pass_rate >'0.6'
    order by user_id asc

这题目是言语理解么？