题解 | #近三个月未完成试卷数为0的用户完成情况#
近三个月未完成试卷数为0的用户完成情况
https://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
with t1 as( select uid, start_time, dense_rank()over(partition by uid order by date_format(start_time,'%Y%m') desc) as rk, if(score is null,0,1) as situation from exam_record ) select uid,count(situation) as complete from t1 where rk<=3 group by uid having count(start_time) =sum(situation) order by complete desc, uid desc
查看28道真题和解析
