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
Leetcode_1107_每日新用户统计_SQL
于 2022-03-01 13:58:20 首次发布