题解 | #近三个月未完成试卷数为0的用户完成情况#
近三个月未完成试卷数为0的用户完成情况
https://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
复盘：开始是用submit_time做的排序，结果导致出来的用户都对不上，后来发现得用start_time,因为有些submit_time是null值
select uid,count(submit_time) as exam_complete_cnt from (select uid,score,exam_id,start_time,submit_time,dense_rank() over(partition by uid order by date_format(start_time,'%Y%m') desc) as ranking from exam_record) as t1 where ranking<=3 group by uid having count(submit_time)=count(uid) order by exam_complete_cnt desc,uid desc
滴滴三面235人在聊