select exam_id,sum(if(score is null,1,0)) as incomplete_cnt,round(sum(if(score is null,1,0))/count(1),3) as incomplete_rate
from exam_record
group by exam_id
having sum(if(score is null,1,0)) <>0