SELECT
  COUNT(exam_id) total_pv,
  COUNT(submit_time) complete_pv,
  COUNT(DISTINCT IF(submit_time IS NOT NULL, exam_id, NULL)) complete_exam_cnt
FROM
  exam_record;