题解 | #近三个月未完成试卷数为0的用户完成情况#
近三个月未完成试卷数为0的用户完成情况
http://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
with a as(
select uid,exam_id,submit_time,
dense_rank()over(partition by uid order by
date_format(start_time,'%Y-%m-01') desc) rk
from exam_record)
select uid,count(exam_id) exam_complete_cnt from a
where (uid) not in (select uid from a where submit_time is null and rk <=3)
and rk<=3
group by uid
order by exam_complete_cnt desc,uid desc
滴滴公司福利 863人发布
查看29道真题和解析