select count(start_time) as total_pv, count(score) as complete_pv, count(distinct case when score is null then null else exam_id end) as complete_exam_cnt from exam_record;