select exam_id, count(start_time) - count(submit_time) as incomplete_cnt,
                round(sum(if(score is null, 1, 0))/count(start_time),3) as complete_rate
from exam_record
group by exam_id
having incomplete_cnt >= 1;