题解 | #牛客每个人最近的登录日期(四)#
牛客每个人最近的登录日期(四)
https://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
select a.date, count(distinct b.user_id) as new from login a left join ( select user_id, min(date) as newdate from login group by 1 ) b on b.newdate = a.date group by a.date order by a.date asc
上海得物信息集团有限公司公司福利 1254人发布