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