select count(*) as total_pv,
count(submit_time) as complete_pv,
count(distinct if(submit_time is null,exam_id,null)) as complete_exam_cnt
from exam_record