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