count不计算null值，条件函数划分很重要

select 
count(exam_id) total_pv,
count(submit_time) complete_pv,
count(distinct if(submit_time is not null,exam_id, null)) complete_exam_cnt
from exam_record