题解 | 牛客每个人最近的登录日期(四)
牛客每个人最近的登录日期(四)
https://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
select l1.date,sum(l1.date=l2.date) as new
from login l1
left join (
select user_id ,min(date) as date
from login
group by user_id
) l2 on l1.user_id=l2.user_id
group by l1.date
查看13道真题和解析