题解 | #牛客每个人最近的登录日期(四)#
牛客每个人最近的登录日期(四)
http://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
select distinct l.date,IFNULL(new,0)
from login l
left join (
select min_date,count(*) new
from (
select min(date) min_date
from login
group by user_id
) t
group by min_date
) t2
on l.date=t2.min_date
order by l.date;