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

题目要求已完成的试卷数，要先筛选出完成作答的试卷，再进行统计