select exam_id,count(submit_time is null or null) as incomplete_cnt,
round(count(submit_time is null or null)/count(*),3) as complete_rate
from exam_record t
group by t.exam_id
having incomplete_cnt > 0

null 值统计，这个在前面的题中已大量出现，题目顺序应该提前