题解 | #统计有未完成状态的试卷的未完成数和未完成率#
统计有未完成状态的试卷的未完成数和未完成率
https://www.nowcoder.com/practice/69fc2b1df4144c0991e4b8280d8aba27
select exam_id,count(*)-count(submit_time) incomplete_cnt,round((count(*)-count(submit_time))/count(*),3) incomplete_rate from exam_record where exam_id in ( select exam_id from exam_record where submit_time is null ) group by exam_id;
上海得物信息集团有限公司公司福利 908人发布
查看3道真题和解析
