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