select exam_id,sum(if(submit_time is null,1,0)) as incomplete_cnt, round(sum(if(submit_time is null,1,0))/count(1),3) as complete_rate from exam_record group by exam_id having sum(if(submit_time is null,1,0)) > 0
select exam_id,sum(if(submit_time is null,1,0)) as incomplete_cnt, round(sum(if(submit_time is null,1,0))/count(1),3) as complete_rate from exam_record group by exam_id having sum(if(submit_time is null,1,0)) > 0
牛客博客，记录你的成长
京公网安备 11010502036488号