题目来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/new-users-daily-count
著作权归领扣网络所有。商业转载请联系官方授权,非商业转载请注明出处。
本人思路:
– 1、按用户分组,找到每个用户首次登陆的日期(即登陆日期最早的),构成临时表temp
– 2、再按日期筛选出符合时间限制的用户,并按日期分组来统计用户数
select min_activity_date as login_date, count(temp.user_id)as user_count
from
(select user_id,min(activity_date)as min_activity_date
from traffic
where activity = 'login'
group by user_id)temp
where datediff('2019-06-30',temp.min_activity_date)<=90
group by min_activity_date