leetcode 1107. 每日新用户统计

# 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;