select 
    COUNT(exam_id) as total_pv, 
    count(submit_time) as complete_pv, 
    # 先去重exam_id 并且分数 不为空
    count(distinct exam_id and score is not null) as complete_exam_cnt
from exam_record e