SELECT exam_id,incomplete_cnt,round(incomplete_cnt/cnt,3) as incomplete_rate
from(SELECT exam_id,count(*)as cnt,count(*)-count(score)as incomplete_cnt
from exam_record
group by exam_id)a
WHERE incomplete_cnt !=0