Leetcode_1107_每日新用户统计_SQL

with t as (
    select user_id, min(activity_date) as login_date
    from traffic
    where activity = 'login'
    group by user_id
)

select login_date, count(user_id) as user_count
from t
where DateDiff("2019-06-30", login_date) <= 90
group by login_date