题解 | #近三个月未完成试卷数为0的用户完成情况#
近三个月未完成试卷数为0的用户完成情况
https://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
select uid, count(m) exam_complete_cnt from (select uid, dense_rank()over(partition by uid order by year(start_time)+month(start_time)/12 desc) m, submit_time f from exam_record) a where m<=3 group by uid having count(m)=count(f) order by exam_complete_cnt desc, uid desc
查看23道真题和解析
