select count(*),count(submit_time) as complete_pv,
count(distinct exam_id,case when submit_time is not null then 1 else null end) as complete_exam_cnt
from exam_record