select
    exam_id,
    count(
        case
        when score is null then 1
        else null
        end
    ) as incomplete_cnt,
    round((count(start_time)-count(submit_time))/count(start_time),3) as incomplete_rate
from
    exam_record
group by
    exam_id
having
    incomplete_cnt>0