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