题解 | #注册当天就完成了试卷的名单第三页#
注册当天就完成了试卷的名单第三页
https://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
找了好久bug没找出来 不知道这个错在哪里
with t0 as (
select
*
from
exam_record
join examination_info using(exam_id)
join user_info using(uid)
),
t1 as (
select
uid
from
t
where
job = '算法'
and tag = '算法'
and date(register_time) = date(submit_time)
)
select
uid,
level,
register_time,
max(score)over(partition by uid) as max_score
from
t0
where
uid in t1
group by uid,level,register_time
order by
max_score desc
limit
6,3