题解 | #统计有未完成状态的试卷的未完成数和未完成率#
统计有未完成状态的试卷的未完成数和未完成率
https://www.nowcoder.com/practice/69fc2b1df4144c0991e4b8280d8aba27
select exam_id, sum(score is null) as incomplete_cnt, round(sum(score is null)/count(*), 3) as incomplete_rate from exam_record group by exam_id having incomplete_cnt > 0;
查看1道真题和解析
投递中国电信等公司10个岗位