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