用户抉择

题解

/ 注册

全部文章 / 题解（共1篇）

题解 | #统计有未完成状态的试卷的未完成数和未完成率#

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 ex...

Mysql

2022-04-22

1 340