题解 | 近三个月未完成试卷数为0的用户完成情况
近三个月未完成试卷数为0的用户完成情况
https://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
select
uid,
count(submit_time) as exam_complete_cnt
from (
select *,
dense_rank() over(partition by uid order by date_format(start_time,'%y-%m') desc) as ranking
from exam_record
) t1
where ranking<=3
group by uid
having exam_complete_cnt = count(uid)
order by exam_complete_cnt desc, uid desc
查看4道真题和解析