olstuusy

分类

/ 注册

全部文章（共1篇）

题解 | #根据指定记录是否存在输出不同情况#

SELECT ui.uid, SUM(IF(score IS NULL AND start_time IS NOT NULL,1,0)) incomplete_cnt, ROUND(AVG(IF(score IS NULL AND start_time IS NOT NULL,1,0)),3) ...

2023-05-25

0 211