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
, count(submit_time) complete_pv
,count(distinct if(submit_time,exam_id,null) ) complete_exam_cnt
from exam_record