根据不同的exam_id,score不为空查询
select
count(id) as total_pv,
count(score) as complete_pv,
count(distinct exam_id and score IS NOT NULL) as complete_exam_cnt
from exam_record

select
count(id) as total_pv,
count(score) as complete_pv,
count(distinct exam_id and score IS NOT NULL) as complete_exam_cnt
from exam_record