请教大佬，下面这个语句问题在哪？提交的时候多一个用户1006， 两个指标的结果都是0 实在想不出问题在哪里。。。 非常感谢 with data_all_level as ( select level, uid , sum(if(submit_time is null and start_time is not null, 1, 0)) incomplete_cnt , round(sum(if(submit_time is null and start_time is not null, 1, 0)) / count(if(start_time is null, 0, 1)), 3) as incomplete_rate from exam_record right join user_info using (uid) group by level, uid ), uid_level_0 as ( select sum(ifnull(uid,0)) level_0_cnt from data_all_level where level = 0 and incomplete_cnt > 2 group by incomplete_cnt ) select uid, incomplete_cnt, ifnull(incomplete_rate, 0) from data_all_level where (if((select level_0_cnt from uid_level_0) > 0 ,(uid in (select uid from data_all_level where level = 0)) ,(uid in (select uid from data_all_level)))) order by incomplete_rate