select count(id) total_pv,sum(if(score is not null,1,0)) complete_pv,
count(distinct if(submit_time is not null,exam_id,null)) complete_exam_cnt
from exam_record;