select count(er.id) as total_pv, count(er.submit_time) as complete_pv, (select count( distinct ex.exam_id) from exam_record ex where ex.submit_time is not null) as complete_exam_cnt from exam_record er