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