SELECT count(*) total_pv, count(score) complete_pv, ( SELECT count(DISTINCT exam_id) FROM exam_record WHERE score IS NOT NULL ) complete_exam_cnt FROM exam_record;
SELECT count(*) total_pv, count(score) complete_pv, ( SELECT count(DISTINCT exam_id) FROM exam_record WHERE score IS NOT NULL ) complete_exam_cnt FROM exam_record;