# Write your MySQL query statement below
select first_date AS login_date, count(distinct user_id) AS user_count
from
(select user_id, min(activity_date) AS first_date
from Traffic
where activity = 'login'
group by user_id) AS t
where datediff('2019-06-30', first_date) <= 90
and datediff('2019-06-30', first_date) >= 0
group by login_date;
leetcode 1107. 每日新用户统计
最新推荐文章于 2024-05-31 17:17:25 发布