select
    count(er.id) as total_pv, 
    sum(case when er.submit_time is not null then 1 else 0 end) as complete_pv, 
    count(distinct case when er.submit_time is not null then er.exam_id end)
    as complete_exam_cnt
from
    exam_record er ;