题解 | #牛客每个人最近的登录日期(四)#
牛客每个人最近的登录日期(四)
http://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
with t_new_user as
(select date,count(1) as new
from
(select min(date) as date
from login
group by user_id
)t
group by date )
select distinct date,ifnull(new,0) as new
from t_new_user
right join login using(date)
order by date
腾讯音乐娱乐集团公司福利 285人发布
