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