image_2022-04-28_18-30-17.png
23.8 KB
#N1141. User Activity for the Past 30 Days I
problem link
#solution
problem link
#solution
select activity_date as day, count(distinct user_id) as active_users from activity
where datediff('2019-07-27', activity_date)<30
group by activity_date