题解 | 牛客每个人最近的登录日期(四)
牛客每个人最近的登录日期(四)
https://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
#min(date)求用户最早登录日期，但无法显示没有新增用户的日期
select
first_log as date, count(*) as new
from
(select
user_id, min(t.date) as first_log
from login t
group by user_id) t1
group by first_log
order by first_log
;
